Forum Discussion
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?
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.
4 Replies
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 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!
