Forum Discussion
powerBI dashboard not refreshing
Hi
I am using web.contents to get data from the web. When I do the data refresh in PowerBI desktop, it works and the latest data would be showing in my powerBI desktop.
Howeverm when I do the scheudle refresh on PowerBI reports ( dashboard), the message says its succeed. But the latest data is not showing in the report.
What might be the issue here?
8 Replies
Ajinkya369Resolver III
Hey powerbbbuuuuu ,
Yes please install the gateway from the link given below:
https://powerbi.microsoft.com/en-us/gateway/
Please follow the instructions given in this documenation to install the gateway:
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem
If your problem is solved then please accept this as solution.
Thank you
- AllisonKennedy
Community Champion
Can you confirm you are doing the schedule refresh on the dataset and not just refreshing the dashboard? What function are you using after web.contents and do you have a gateway?Thanks for the quick response.
Yes, the refresh scheudle was set on the datasets.
The code looks like: Source = Json.Documents(Web.Contents( "In there, It's just the urls that calls the API for data")).
Currently, there is no gateway set. Is this the issue?
- AllisonKennedyYou should be able to see the refresh history on the dataset, what does that look like? https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-data#:~:text=You%20can%20find%20a%20link,datasets%20in%20a%20centralized%20way.
- amitchandak
Super User
powerbbbuuuuu , publish to web/embedded data or when open on power bi service data is nor refreshed.
I faced this with published/share to the web dashboard was not showing the latest data yesterday, but it is correctly reflecting today.
Power bi desktop and when I open on service from workspace link. it was working. Not the published link. But today publish link also showing the latest data.
V-lianl-msftCommunity Support
Hi powerbbbuuuuu ,
This thread may also help. Add credentials to web.contents and set up anonymous connection.
https://community.powerbi.com/t5/Power-Query/Data-source-does-not-update-in-web-Power-BI/td-p/182262
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.- V-lianl-msft
Hi powerbbbuuuuu ,
Is this problem sloved?
If not, please let me know.Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
