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.
Comments
-
v-jtian-msft
on:
Error opening report in Desktop Version
-
v-jtian-msft
on:
Issue with X-Axis Constant Line Not Appearing in P...
-
v-jtian-msft
on:
Unable to connect to Semantic Models
-
v-xiaoyan-msft
on:
Accent bar (color) on new card not working (calcul...
-
v-jtian-msft
on:
Help - Error when trying to save to onedrive from ...
-
v-xiaoyan-msft
on:
could not establish trust relationship for the ssl...
-
v-jtian-msft
on:
An error occured while rending the report.
-
v-xiaoyan-msft
on:
Power BI Desktop Crashes Completely
-
nleuck_101
on:
Issues with calculating previous day using Date ta...
- reilbeck on: Bug report
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