Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

willtrickettwwd

Issue connecting Power BI Desktop to SQL Server

Submitted by on ‎12-10-2024 09:30 AM

Hello -

 

Starting a few days ago, users are unable to connect to a SQL server (Synapse serverless SQL pool) via Power BI desktop.  "The serivce returned an invalid token.  Please contact your IT administrator if this issue persists."

 

Clearing credentials and re-entering them doesn't fix the issue.  We are able to refresh reports connected to this server in Power BI Service, and connect to the server using other 3rd party tools such as SQL Server Management Studio.

 

image.png

Status: Investigating
See more ideas labeled with:
1 Comment (1 New)
Comments
Anonymous
Not applicable
‎12-11-2024 12:08 AM

Hi @willtrickettwwd ,

 

Power BI has released the latest version on 12/9.please make sure you are using the latest version of Power BI Desktop.

If you are using managed identities for authentication, ensure that the managed identity has the appropriate permissions and is correctly configured. The user account should had the necessary permissions to access the Synapse serverless SQL pool.
Please also check your token used for authentication is not expired. and firewall settings allow connections from Power BI Desktop to the Synapse serverless SQL pool.

 

Best Regards,
Community Support Team _ Caitlyn

 

Idea Statuses