Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
Hi, we've set up reports in Power BI Desktop that use a data model created in Power BI desktop. The data source for this data model is a set of spreadsheets in Sharepoint online.
When we upload these reports to the Power BI service, we're unsure which refresh option should apply and how to get them to refresh:
Do we need to use the refresh scheduler with these report? They're not on premises sources so i presume a data gateway isn't necessary and they don't automatically refresh so i presume this doesn't apply either.
When we try the schedule refresh option, we get 'the data source can't be refreshed because the credentials are invalid. Please update your credentials and try again.'
We don't really understand why the credentials are not saved with the report. When we click Edit Credentials, none of the authentication methods work. With the OAuth2 option we get 'Network Error (tcp_error) A communication error occurred: "No route to host"....
Our IT department don't have any experience of setting this up and don't know what to do. They have asked us to post a message to request some advice. Any help would be much appreciated as this is holding us back at the moment.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.