Forum Discussion
Analyze in Excel - Refresh Pivot Table
Hi, We encounter the following problem when analyzing a Power BI Dataset in Excel: We want to keep the resulting Pivot Table up to date, so we enable the "Refresh Data when opening file" opti...
how are you connecting to the table, maybe the table is locking
Hi,
I don't really know what you mean by 'connecting to the table'. We are using the "Analyze in Excel" function in the Power BI Service, open the .odc file in excel and create the pivot table. For the connection properties, we have set "Always use connection file", "Save password" and "Refresh data when opening file" options.