Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Next up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now

Auto Refresh Database and Publish

As information input to dashboard will be online with ERP, Power BI Desktop should have the option of Refreshing (database) itself every 30 minutes (for example) and also Publishing the content afterwards. It would totally help the live information need.
Status: Needs Votes
Comments
kam_siu
New Member
on the command line, it can call the power BI desktop with the .pbix file ideally, have the command line option to open, refresh and publish. I try a couple of Powershell script in GitHub, but not working, run with error. Does Power BI Desktop had the OLE automation, so I can use any scripting language to automate the task, similar to excel
fbcideas_migusr
New Member
Status changed to: Needs Votes