If you’re interested in Power BI (or the Power platform in general), you might be interested in checking out the release overview guides of “2019 release wave 2” for these products: https://dynamics.microsoft.com/en-us/business-applications/product-updates/#overview-guides-and-videos Interesting stuff ahead! (I like they’re doing something with data lineage, which is about time)
Tag: power bi
Connect to Power BI Report Server with SSMS
Sometimes you want to connect to a report server instance using Management Studio, for example to create a new security role or modify an existing one. Recently I tried to log into our newly installed Power BI Report Server (March 2018 edition). I was greeted with the following error: The Reporting Services instance could not […]
Book Review – Analyzing Data with Microsoft Power BI and Power Pivot for Excel
As preparation for my session at Techorama.be about data modeling in self-service BI, I decided to read the book Analyzing Data with Microsoft Power BI and Power Pivot for Excel by Marco Russo and Alberto Ferrari. The title is quite a mouthful but it gets the point across: the book mostly deals with how to correctly build […]
Excel Rendering In Power BI Report Server: You Are Not Licensed To Use This Feature
I recently migrated an SSRS 2017 instance to a Power BI Report Server environment, as you can read in the blog post Migrate SSRS 2017 to Power BI Report Server. After quite some issues, the PBI RS Portal worked and I could happily browse SSRS and Power BI Desktop reports. The last on the last […]
Migrate SSRS 2017 to Power BI Report Server
UPDATE: The blog post doesn’t make this exactly clear, but fiddling around with the report database to get the upgrade working isn’t supported by Microsoft. However, someone from the SSRS team told me the March 2018 release of Power BI Report Server has fixed some bugs, so you should try to upgrade the normal way. […]
Data Modeling for Self-Service BI @ Techorama 2018
I’m delighted to announce I’ll be giving a session about data modeling in a self-service BI environment at Techorama 2018 (the Internet is divided on the correct spelling: modelling or modeling. Apparently it depends on which side of the pond you’re on). Techorama is one of the biggest Microsoft-oriented tech events in Europe (it takes […]
Where’s the Trend Line in Power BI Desktop?
A quick blog post on finding where the trend line is hiding in Power BI Desktop. Docs will state it is in the analytics pane for certain types of visualization. However, it doesn’t always show up: (I really resisted the urge to post another “Dude, where is my car” image) So why did the trend […]
Power BI Announcements Summary
It was a crazy week for Power BI. There were quite a lot of announcements, so I’ll try to wrap them up in one single blog post and share my thoughts as well. POWER BI DESKTOP Again an amazing release (May 2017). Noticeable features are: Measures on top of live SSAS Tabular connections! I’ve been […]
PASS BA Marathon – Spring Edition Q&A
The PASS BA Marathon Spring Edition was quite a success. A lot of people tuned in (over 400), the webinar went great (lots of great feedback!) and there were a lot of interesting questions. You can find the recording here. Since I didn’t have the time to answer all questions, I’ll tackle them in this […]
Hands-On Data Analysis With Power BI Desktop at PASS BA Marathon
I’m delighted to announce I’ll give a session at the next PASS BA webinar marathon. The topic of this marathon is Data Driven Storytelling and Data Discovery. My session will focus on working with Power BI Desktop: getting data in, cleaning it, creating a model and visualizing the data. It will be mostly demos and just […]