Forum Discussion

mbbozzuto's avatar
mbbozzuto
Icon for Advocate II rankAdvocate II
3 years ago
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...
Need Help
  • mbbozzuto's avatar
    mbbozzuto
    3 years ago

    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's avatar
GilbertQ
Icon for Super User rankSuper User
3 years ago

Ok that is weird why it does that!

mbbozzuto's avatar
mbbozzuto
Icon for Advocate II rankAdvocate II
3 years ago

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.