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

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
mbbozzuto
Advocate II
Advocate II

View OLAP query running in Excel

Hi - I am pulling data into Excel from a Power BI service Dataset using Pivot Table query.  My Excel workbook has multiple sheets/pivot tables using the same Dataset connection.  When I refresh the connection or change any of the slicers, it automatically starts refreshing.  I can see in the lower right that it is running each of the queries sequentially because it will show that it is running the query, then it will clear out, and then start querying again.

 

One of the queries appears to be getting hung up but I don't know for which table.

 

Is there a way in Excel to see the log/output of which query is being executed?

1 ACCEPTED SOLUTION

@GilbertQ whenever I click the "Refresh" button it still tries to refresh all pivot tables connected to the data source, so it seems to do the same as if I clicked on "Refresh All" - is this because all tabs share the same data source connection?

 

I will separately look into the Azure logs as a long term option.

View solution in original post

4 REPLIES 4
GilbertQ
Super User
Super User

Hi @mbbozzuto 

 

If you are using Power BI Premium or Premium Per User you can use Log Analytics to view the queries?

Using Azure Log Analytics in Power BI - Power BI | Microsoft Learn

 

Or if you are in Excel, you can click on the data tab in the ribbon and go to each individual sheet and click on the dropdown on Refresh All and select Refresh. This will only refresh the current pivot table. Which will allow you to see which pivot table is failing.

GilbertQ_0-1692653831498.png

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

@GilbertQ whenever I click the "Refresh" button it still tries to refresh all pivot tables connected to the data source, so it seems to do the same as if I clicked on "Refresh All" - is this because all tabs share the same data source connection?

 

I will separately look into the Azure logs as a long term option.

Ok that is weird why it does that!





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Thanks @GilbertQ - I take that as an indication that you were able to recreate the same on your machine and it is not just me.  I hope that Microsoft puts more into Excel because with this data connection and then if they could replace VBA with Python as a scripting back-end (I think I read rumours of this), it would enable the ability to create easily deployed interactive data applications.

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors