Authentication Type in Power BI Service

Anonymous Even if your SQL Server is hosted online, you might still need to use an on-premises data gateway if your Power BI Service environment is not within the same network as your SQL Server. The gateway allows secure data transfer between your Power BI Service and your on-premises data sources. Ensure that you have the appropriate gateway configured if needed.

You can check the following steps:

1)After publishing your report to the Power BI Service, you may need to configure the data source settings within the service environment.

2)Go to the dataset settings in the Power BI Service, find your data source, and ensure that the credentials and connection details are correctly configured.

3)If Windows Authentication is not an option in the service, you may need to switch to another authentication method, such as Basic Authentication, and provide the necessary credentials.

If it helps, please mark it as an accepted solution so that other users can find it more easily.