cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

Refresh Data and Publish to Web Automatically

Hi,

 

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.

Best regards,

André Jorge

7 REPLIES 7
Highlighted
Super User II
Super User II

Re: Refresh Data and Publish to Web Automatically

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

 

Regards,



If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Happy to help!

LaDataWeb Blog


Highlighted
New Member

Re: Refresh Data and Publish to Web Automatically

Is there any update on if this is available at this point? 

Highlighted
New Member

Re: Refresh Data and Publish to Web Automatically

Were you ever able to find something to make this work? I am running into the same issue. @anpjorge 

Highlighted
Frequent Visitor

Re: Refresh Data and Publish to Web Automatically

I am running into the same problem. I'd rather not have to manually publish each morning. I need to auto-refresh and then auto-publish.

Highlighted
New Member

Re: Refresh Data and Publish to Web Automatically

I also would like to know if theres any update on this problem

Highlighted
Regular Visitor

Re: Refresh Data and Publish to Web Automatically

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. 

 

Thanks.

Highlighted
New Member

Re: Refresh Data and Publish to Web Automatically

Hi everyone,

 

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.

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors