Forum Discussion

PunitPrabhu89's avatar
PunitPrabhu89
New Member
5 months ago
Solved

Programatically Refresh Power Bi Desktop file and save it

i have multiple clients from whom i get data , and i have compute engine to process and get aggregated KPI file . I use that file to create Power bi report and i upload it to blob and expose it to fr...
Need Help
  • v-tejrama's avatar
    v-tejrama
    5 months ago

    Hi PunitPrabhu89 ,

    Thanks for reaching out to the Microsoft fabric community forum.

     

    I see you're looking to automate data updates for various clients by refreshing and saving a Power BI Desktop file locally using PowerShell or Python, without relying on Power BI Service, APIs, Power Automate, or licensing.

     

    However, this isn't supported by Power BI Desktop, as it lacks a command line interface, SDK, PowerShell module, or Python functionality to programmatically open, refresh, and save PBIX files. Refreshing is only possible at the dataset level within the Desktop engine, and Microsoft supports automation through the Service, XMLA, or REST APIs not directly with PBIX files.

     

    That's why PowerShell or Python attempts don't work, and mouse click automation isn't reliable for production. For license free local automation, the recommended method is to use a parameterized PBIT template to create client-specific PBIX files, rather than refreshing an existing PBIX.

    Best Regards,
    Tejaswi.
    Community Support

v-tejrama's avatar
v-tejrama
Community Support
5 months ago

Hi PunitPrabhu89 ,

Thanks for reaching out to the Microsoft fabric community forum.

 

I see you're looking to automate data updates for various clients by refreshing and saving a Power BI Desktop file locally using PowerShell or Python, without relying on Power BI Service, APIs, Power Automate, or licensing.

 

However, this isn't supported by Power BI Desktop, as it lacks a command line interface, SDK, PowerShell module, or Python functionality to programmatically open, refresh, and save PBIX files. Refreshing is only possible at the dataset level within the Desktop engine, and Microsoft supports automation through the Service, XMLA, or REST APIs not directly with PBIX files.

 

That's why PowerShell or Python attempts don't work, and mouse click automation isn't reliable for production. For license free local automation, the recommended method is to use a parameterized PBIT template to create client-specific PBIX files, rather than refreshing an existing PBIX.

Best Regards,
Tejaswi.
Community Support

  • v-tejrama's avatar
    v-tejrama
    Community Support
    5 months ago

    Hi PunitPrabhu89 ,

     

    I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

    Thank you.

    • v-tejrama's avatar
      v-tejrama
      Community Support
      5 months ago

      Hi PunitPrabhu89 ,


      I wanted to follow up and see if you had a chance to review the information shared. If you have any further questions or need additional assistance, feel free to reach out.

      Thank you.