Forum Discussion
How to refresh the data
My report (PBIX file) is developed with Power BI Desktop and saved in my OneDrive 365. I published this report in premium workspace in service. When I go to check the report in service it is there and works fine. On the following day in the morning I want to refresh my data so this is what I do
- Go to my PBIX file and do refresh
- Then I have to republish and replace exisiting
- I then go to service and do the refresh to see the changes in data
Is there a way to do this automatically daily so the user of my reports just refreshes the browser in order to get new data in?
Good job,
That's normal it can take couple minutes to see the updates applied on the page or just refresh it and you will see it right after
19 Replies
I was able to adjust the code and set up the refresh schedule. It did run this morning successfully according to the message however the report did not show fresh data only after I manually clicked here
Good job,
That's normal it can take couple minutes to see the updates applied on the page or just refresh it and you will see it right after
looks ok now
I am using API calls in my power queries. Is that why I cant refresh?
I think you are misusing the fonctionality of OneDrive integration
The purpose is clearly not for refreshing the model
Power BI Desktop OneDrive and SharePoint integration - Power BI | Microsoft Learn
You might want to use different approach if you want to refresh the model automatically.
Where is "Query 1" coming from? I have 12 queries in my report. None of them are called "Query 1"
When go here Data Source Settings dialog in Power Query Editor, and then select Data Sources In Current File i see this which is file I am using to get data for one of my tables. Is that why? This file is in my OneDrive
ok fair enough how would I adjust this. This is the data that i have to manually update every week or so in excel file which is use as a source for my blank query. This file is for one table in this report. All other tables are done via blank query/api calls
I scheduled another one to run at 11 am and as of now looks like it is still running (see red arrow). when I manually refresh it it takes only like 20-30 seconds
Refresh the whole page
