Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
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.
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.
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
@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.
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
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?
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.
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
97 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |