View OLAP query running in Excel

[mbbozzuto]

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?

[GilbertQ]

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.

[mbbozzuto · 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.

[GilbertQ]

Ok that is weird why it does that!

[mbbozzuto]

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.