Last week I published a post on how I used Power BI Desktop to import PASS Summit 2019 session schedule and build a few reports for myself to help me sort my sessions of interest by day/time/room and decide which ones to attend. In that post, I had initially tried to import the schedule with … Continue reading Another look at PASS Summit 2019 sessions using Power BI Desktop and “Get Data From Web”
Category: Power BI
PASS Summit 2019 sessions review: What sessions to attend?
PASS Summit is only 2 weeks away. It is time to review the sessions and decide which ones to attend. You can find the published schedule here. This is a great at-a-glance look. There is also a searchable version of the schedule published here. You can use this one to search by keyword or track … Continue reading PASS Summit 2019 sessions review: What sessions to attend?
Connecting live from Power BI Desktop to SSAS generates this error: The Server you’re trying to connect to doesn’t have any models or you don’t have permissions to access them.
I recently ran into an error while connecting live from Power BI Desktop to a SSAS server. Everything was on-premises.There was no cloud component involved. I had full admin rights to the SSAS server and could see all databases and models from SSMS and other tools but was getting this error from PBI Desktop. The … Continue reading Connecting live from Power BI Desktop to SSAS generates this error: The Server you’re trying to connect to doesn’t have any models or you don’t have permissions to access them.
Calculated measures in Power BI Desktop reports connected live to SSAS Tabular.
May release of Power BI Desktop adds the capability of adding new calculated measures to a report when you are connected live to SSAS tabular. This is great because before this release, once you connected live to SSAS you could not make any changes to the model. Official announcement Ideally the SSAS database has all … Continue reading Calculated measures in Power BI Desktop reports connected live to SSAS Tabular.