I have defined the external connection as a reference to stored procedure in SQL.
This problem occurs only on computers of the users I distribute MyFile.xlsb. How to disable it? How to run refresh all only on demand. Needless to add it is very annoying feature. with a VBA Macro instead of manual clicking.
ps: I used the macro recorder in order to do step 2. Relationships are the heart of Power BI modeling, and Power BI Desktop has a way to help and identify the relationships based on the source, or the data.
After that the PQ queries are gone and the tables are still there and untouched. Power BI design tip, disable the auto-detect relationship. run Document Inspector and clean XML data. Whenever I change windows of opened workbooks and come back to MyFile.xlsb where I have defined external connection, the refresh of all pivot tables in MyFile.xlsb runs automatically. Heres my current (and much quicker) workflow: disable Power Query addin.
0 kommentar(er)
