Forum Discussion
Solved
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 c...
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.