Forum Discussion
Refreshing report with Web and SQL on-premise data source
I have a report uploaded to the Power BI service and I want to be able to refresh this report on powerbi.com. The report contains queries that use an on-premise SQL server data source and queries tha...
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
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.
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