Forum Discussion
Refreshing report with Web and SQL on-premise data source
You have to use OAuth2 as authentication.
If this post helps, then please consider Accept it as the solution and give it a thumbs up
As per error message the issue is with crdentails, to validate this try to refresh the PBIX on your local desktop and see if it fails.
also under data source setting make sure you have update the credentails for source.
If this post helps, then please consider Accept it as the solution and give it a thumbs up
In Power BI Desktop I can refresh my report as it should. However, I cannot do this in the service.
The problem is that refreshing my SQL Server source is working while it does not work for my web sources. In the data set of the report I have mapped my SQL data source in the gateway to the SQL Server using my credentials. This works. However, the mapping of the Sharepoint Excel sources does not work because it shows the above issue. I find this message strange because I connected the web source using Anonymous (so no credentials) and now suddenly credentials seem to be the problem.
Are you merging the data from SQL and Web together, if yes then you have to enable "Allow user's cloud data sources to refresh through this gateway cluster" option in Gateway setting. (Merge or append on-premises and cloud data sources - Power BI | Microsoft Docs)
If this post helps, then please consider Accept it as the solution and give it a thumbs up
This report indeed has a data set in which data from the SQL Server and from the web are refreshed all at once. The option you mentioned was already enabled. My configuration looks like this:
and
where the last picture is my configuration of one of the Web data sets I try to establish.