Scheduled refresh for Power BI Desktop

[dhandapani]

Hi,

I have a PBIX file which is stored in a shared drive (not sharepoint or one drive). I would like to schedule refresh for the same.

But the data source credentials are disabled for me due to the nature of data source. And i do not have the "refresh page" option which comes under visualization tab.

Is there a way to schedule or Automate the manual process of Power BI desktop refresh - Meaning, the automation should open the PBIX from the sharedrive, click on refresh and close the PBIX (this should open on the Scheduled date/time).

Please let me know if we have Power Automate or python automation for the same.

[selimovd]

Hey @dhandapani ,

there is no support for something like this in Power BI.

You have to figure out a way how you can do that by yourself. So maybe a python script could do that, maybe Power Automate for Desktop, maybe Autohotkey.

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards
Denis

Blog: WhatTheFact.bi
Follow me: twitter.com/DenSelimovic

[dhandapani]

Please let me know if you have python script or power automate procedure