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...
AllisonKennedy
Community Champion
Community ChampionCan 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.
V-lianl-msftCommunity Support
Hi powerbbbuuuuu ,
1. Install the on premises gateway
2.Use the on-premises data gateway app
3. When configuring the source, use "Anonymous credentials" AND mark "Skip test connection"Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.