Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

SQL query from Dataverse connector - Doesn't update the query if you remove or include columns

Hi all,   Thanks in advance for all the support you provide to the community!   I am having some issues with the connector I have in a Power BI dashboard to some tables in Dataverse. Everything i...
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Anonymous 

     

    It may take some time for changes to the columns to be reflected in Power Query. Are you able to see those changes now?

     

    To clear cache in Power BI Desktop, you can go to File > Options and settings > Options. Under GLOBAL, select Data Load, and then select Clear Cache.

     

    Best Regards,
    Jing

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hey Jing,

 

Thanks a lot for your message!

 

After testing a few times, with a colleague, we have realised that is an issue from the cache. After evrey change you do in dataverse tables, you need to clean the cache for the respective dashboard.

 

Thanks again for the help! I really appreciate it!

 

Best,

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    It's good news! Thank you as well!