Forum Discussion
View OLAP query running in Excel
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.
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!
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.