Connecting datasets to SQL database in Power BI Service for automatic refresh

Hi Anonymous ,

It seems the error message you are receiving is related to a privacy setting in Power BI Service. By default, Power BI Service applies a privacy level to each data source based on the data source type and the location of the data source. If you are combining data from multiple data sources with different privacy levels, you may encounter this error.

To resolve this issue, you can try adjusting the privacy levels for your data sources in Power BI Desktop before publishing the report to Power BI Service. You can do this by going to "File" -> "Options and settings" -> "Options" -> "Security" -> "Data source settings". From there, you can select each data source and adjust the privacy level as needed.

Once you have adjusted the privacy levels in Power BI Desktop, you can publish the report to Power BI Service and set up automatic refresh. To do this, go to "Settings" -> "Datasets" -> select your dataset -> "Schedule Refresh". From there, you can set up a refresh schedule and configure any necessary credentials or gateways.

How to Get Your Question Answered Quickly 

If it does not help, please provide more details .

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.