Forum Discussion
anpjorge
8 years agoNew 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...
Anonymous
6 years agoNot applicable
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.
yaplester
6 years agoNew Member
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.