This is episode 65 recorded on September 11th, 2018 where John & Jason talk to Microsoft MVP and Regional Director Reza Rad about Reza’s Power BI background, and our joint meetup at Microsoft Ignite.
Reza Rad is an Author, Trainer, Speaker and Consultant. He has a BSc in Computer engineering; he has more than 15 years’ experience in databases, programming and development mostly on Microsoft technologies. He is a Microsoft Data Platform MVP for seven continues years (from 2011 till now) for his dedication in Microsoft BI. Reza is author of Power BI from Rookie to Rock Star and some other books. He is training and consulting on Microsoft BI and Data Analytics technologies.
This is episode 59 recorded on July 31st, 2018 where John & Jason talk about SharePoint Saturday NYC, sessions for Microsoft Ignite, and interview Will Thompson from the Power BI Desktop Team at Microsoft.
This is episode 58 recorded on July 25th 2018 where John & Jason talk about Business Application Summit after-the-fact, The Road Ahead for Power BI & SharePoint blog post, and do a deep dive on the Power BI Desktop update for July.
This is episode 55 recorded on June 28th 2018 where John & Jason talk about a few recent bugs and service interruptions, the recent Power of the Cloud conference, PowerApps, Flow, and some recent improvements to the usability of the On Premises Data Gateway
Hey all – John here. One of the things that we get asked frequently is how to report on SharePoint data. The answer is of course, “well, it’s easy, but it depends”.
In the spirit of clearing up the “it depends” part, I’m in the process of writing a series of articles that walks through the nuances of the various SharePoint complex data types. The first one shows some options for reporting on multi-value SharePoint columns, and includes tricks that pertain to more sources than just SharePoint.
-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…
-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
-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
-Various scenarios are supported, including the following:
-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
This is episode 26 recorded on December 6th, 2017 from SharePointFest Chicago… where John & Jason talk about the latest updates to the OnPrem Data Gateway, the technical reference implementation for enterprise BI and reporting, and the latest news for Power BI Developers.