Forum Discussion

crossover's avatar
crossover
Advocate I
6 years ago
Solved

PowerQuery Privacy settings not retained

Hi! I'm new to PowerQuery but not so much to Excel and struggling with a weird Privacy settings issue I have a few workbooks completed with PowerQuery. One is simply fetching a table from another wo...
Data Protection
Need Help
  • dax's avatar
    dax
    6 years ago

    Hi crossover , 

    As mentioned above, the individual file preferences for privacy level is saved in each computer, not with the file itself. You could try to set "ignore privacy level " in on query option or each prompt windows in each computer. You could refer to Privacy levels not saving for file but per user in file  for details. And if you still have problem, you could ask problem in this forum in above link.

    Best Regards,
    Zoe Zhi

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Refresh information is not stored in the file, its stored in the PC's cache.  Thats why you get this message again on the 2nd computer.

  • crossover's avatar
    crossover
    Advocate I
    6 years ago

    Fair enough.

    I would be OK with configuring each PC individually in case the settings would actually be saved locally.

     

    The issue I'm facing is that after doing the setup in the 2nd PC, settings are reset back in the 1st PC (easy to test with VNC connection to the 2nd PC). And vice versa - updating settings on the 1st PC, launches the Privacy popup next time I open the file in a second PC.

    This couldn't be an expected behaviour, right?

     

    For the user it's mostly just cosmetics (push a single extra button) - although still better avoided. However I'm looking to launch some scheduled VBA code, which also refresh this data connection, however this popup halts this process.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Power BI Desktop is a development tool, so the thing you are testing isn't the intended use of the product.  There is likely a change occuring in the file which is causing the first computer to recheck.

       

      The expectation is that if you have a file that multiple people need to use (as consumers not developers), you publish it into the service inside a workspace and provide access using the Apps.

      • crossover's avatar
        crossover
        Advocate I
        6 years ago

        Thanks for the feedback. Given I'm new to Microsoft BI products, I might have also mixed up the community boards? I'm launching this only from Excel and running PowerQuery to load & transform data between two Excel workbooks. I'm not running a Power BI software.