Issue: Unable to schedule refresh in PBI Service for a Web Data Source
Error:Query contains unsupported function. Function name: Web.Contents
We used Anonymous Auth in PBI Desktop for particular Web Source as the Access Token was passed in M Query. The Auth may differ based on the data source you have.
The Privacy Level should be set to Organizational privacy level.
Publish the pbix to PBI Service and make sure to updated Privacy on dataset on Power BI Service as well i.e. Dataset Setting –> Data Source Credentials -> Edit Credentials -> Make sure to use credentials with same Auth/Privacy as in PBI Desktop -> OK
Privacy Level in Power BI Desktop:
File -> Options and Settings -> Options -> Privacy Level of Global Setting -> Combine data according to privacy of each data source -> File setting -> Combine data according to privacy of each data
Data source Settings -> Edit Permissions -> Choose Auth as per you data source -> OK -> Privacy Level -> choose Organizational