Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
bdd9
Frequent Visitor

Is there a tool to debug my Power BI desktop queries & data model..preferably excel

Is there a tool to debug my queries & data model?

 

I have some merged and appended queries in which my results are not what I'd expect.

 

I'd like to link my Power BI desktop data model to excel in order to "debug" my data queries and model.

 

On the surface, the "Connect to Data" capability in the Power Bi excel add-in would be sufficient but...perhaps I am not fully understanding its capabilities. it appears that I can only use measures to see the data values from my data model.

 

I'd like to be able to link my queries and data model tables to excel tables for me view see each row in the data and debug it.

 

I hope this makes sense. 

 

thanks

1 ACCEPTED SOLUTION
stretcharm
Memorable Member
Memorable Member

I tend to use the table and matrix to help check my figures. I also build extra queries to test my data.

 

You can also connect to powerbi as if it was an an analysis services server from Excel/SQL management Studio etc

 

It's a little bit tricky but this post expains how to do it.

 

http://biinsight.com/connect-to-power-bi-desktop-model-from-excel-and-ssms/?lipi=urn%3Ali%3Apage%3Ad...

 

If you've pushed your model to the powerbi service then you can use the excel add in

https://docs.microsoft.com/en-us/power-bi/service-analyze-in-excel

 

You can also add excel tables into your powerbi model and use other merged or appended queries in your model to check it.

 

View solution in original post

1 REPLY 1
stretcharm
Memorable Member
Memorable Member

I tend to use the table and matrix to help check my figures. I also build extra queries to test my data.

 

You can also connect to powerbi as if it was an an analysis services server from Excel/SQL management Studio etc

 

It's a little bit tricky but this post expains how to do it.

 

http://biinsight.com/connect-to-power-bi-desktop-model-from-excel-and-ssms/?lipi=urn%3Ali%3Apage%3Ad...

 

If you've pushed your model to the powerbi service then you can use the excel add in

https://docs.microsoft.com/en-us/power-bi/service-analyze-in-excel

 

You can also add excel tables into your powerbi model and use other merged or appended queries in your model to check it.

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.