I develop a dashboard, which is linked to a datawarehouse and some excel files at my computer. Everyday, when I get to work I have to open the Power BI Desktop, refresh de data and publish to the web (so the link that I shared to my collegues is up to date).
Is there any way to automatically do this? Can anybody help me?
Thanks for your help.
There isn't something to do that. However you can install a Power Bi On premise gateway on a server that has connectivity with the data and schedule refresh of data in order to be up to date on the link you share automatically. That 's the way power bi refreshes data.
Here is some doc: https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem
Hello everyone, I have the same issue, I need automate the publish in PowerBi, I have talk with many people in groups of powerbi the unique solution found is create a macro to automate the publish in power bi.. if someone find another way to automate please share with us.
I have found a way to do the data refresh (data source = excel file,text file). What we need is actually use a Gateway and use that gateway in Power BI web version to create a datasource. From the created data source you can then configure the link of your source data (link from File). Then for the refresh schedule, you need to set up from the data set that was uploaded when you publish.
Hope it helps.
Don't miss the Power BI Dev Camp this week!
Check out a full recap of the month!
Check out the winners of the recent 'Can You Solve These?' community challenge!
Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.