cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
powerbbbuuuuu
Frequent Visitor

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 8
V-lianl-msft
Community Support
Community 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.

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.

Ajinkya369
Resolver III
Resolver 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

amitchandak
Super User IV
Super User IV

@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.

 

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

AllisonKennedy
Super User III
Super User III

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?


Has this post solved your problem? Please mark it as a 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. ?


I work as a trainer and consultant for Microsoft 365, specialising in Power BI and Power Query. 


www.excelwithallison.com

@AllisonKennedy 

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.

You 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%20l....


Has this post solved your problem? Please mark it as a 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. ?


I work as a trainer and consultant for Microsoft 365, specialising in Power BI and Power Query. 


www.excelwithallison.com

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors