Forum Discussion

gulsemin's avatar
gulsemin
Regular Visitor
2 years ago

Unable connect to the data source

The report works fine on my own desktop, but when I publish it here, I receive the error message. I defined the gateway within the company to the SQL server and received all access, there is no probl...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi gulsemin ,

 

Here are a few things you could try:

1.Check the data source settings: In Power BI Desktop, select File, Options and Settings, and then Data Source Settings. Find the data source with the cached settings and use the “Clear Permissions” button to reset.

2.Check the server and database name: Make sure the server and database name match what was entered in Power BI Desktop and the data source configured for the gateway.

3.Check your account: Make sure your account is listed in the Users tab of the data source within the gateway configuration.

4.Check all data sources: Make sure all the data sources in your Power BI Desktop file are configured with the gateway.

Try to run as administrator to open Power BI Desktop and re-connect to SQL server.

 

Best regards.
Community Support Team_Caitlyn