Episode 30 – New Years News

This is episode 30 recorded in January 1st 2018… where John & Jason talk about the news from the past few weeks in Power BI, Office 365, and Azure.

Show Notes:

On-premises data gateway December update

-includes a number of bug fixes and improvements to previously released features
-matches the Mashup Engine that was released as a part of the Power BI Desktop December update

Sync members from O365 Modern group to a mail-enabled security group

-This is one of the issues that we run into because Power BI is NOT a part of Office 365
-The solution that Adam shows is a viable, one time solution but does not solve the longer term issue
-This can be scripted to run daily, but it is duplicating groups at that point which will ultimately cause problems
-We love Adam Saxton & Patrick LeBlank and recommend people subscribe to the YouTube Channel GuyInACube
-We don’t actually recommend you do this…

The Reddit Solution Template

-Point solution for Reddit
-Similar solutions exist for Twitter, Facebook, & Bing News
-What are Solution Templates anyway?
-Who is this for? Social Media Managers… that use Reddit
Server aliases for Azure Analysis Services

-Aliasing is always a good idea
-migration situations
-easier to remember
-obfuscates actual server information
-allows the use of Azure Traffic Manager
-Users can connect to the server from Power BI Desktop (in addition to other client tools) using the link:// format

Azure Analysis Services integration with Azure Diagnostic Logs

-Various scenarios are supported, including the following:
-Auditing
-Monitoring of server health
-Derivation of usage metrics
-Understanding which user groups are using which datasets and when
-Detection of long-running or problematic queries
-Detection of users experiencing errors
-Consume diagnostic logs in Power BI
-give you a text file that contains an M expression, which can be pasted into a blank query in Power BI Desktop
-The expression contains the current Log Analytics query and consumes from the Log Analytics REST API

Leave a Reply