Error when refreshing data model

[dev99]

Hi, I am getitng this error when I am trying to refresh a data model in PBI Service. It refreshes successfully in PBI Desktop but shows this error in PBI Service: Data source error: {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"SharePoint: Request failed: Unable to connect to the remote server"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"SharePoint"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"https://test.sharepoint.com/"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: CS.
Cluster URI: WABI-CANADA-CENTRAL-B-PRIMARY-redirect.analysis.windows.net
Activity ID: --
Request ID: --
Time: 2025-03-13 10:22:40Z

[KalpeshClearDu]

Hey all,

I am working as data analyst and i got error as OLE DB or ODBC error:53300: too many connections for role "powerbiuser". I am working on direct query with postgresql database and when i do refresh above error shows frequently. I tried to increse connection in power bi settings but no effect! If anyone has the proper solution how to resolve this issue, please let me know. Thanks in Advance.

[lutz_bendlin]

Talk to your PostGres DB admin.

[v-pagayam-msft · Accepted solution]

Hi @dev99  ,
Thank you for the patience!

If still faces the same issue then please consider raising a support ticket for further assistance.

To raise a support ticket for Fabric and Power BI, kindly follow the steps outlined in the following guide:

How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

If this post helps, please give us Kudos and consider marking it Accept as solution to assist other members in finding it more easily.
Thank you for being a part of Microsoft Fabric Community Forum!

[v-pagayam-msft]

Hi @dev99 ,
May I ask if you have gotten this issue resolved?
If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

Thank you.

[dev99]

Hi, I have tried all the recommended solutions below but the problem is still not resolved. It still shows the same error. I am able to refresh it in my desktop but not in service.

[v-pagayam-msft]

Hi @dev99 ,
I wanted to check in on your situation regarding the issue. Have you resolved it? If you have, please consider marking the reply that helped you or sharing your solution. It would be greatly appreciated by others in the community who may have the same question.
Thank you.

[dev99]

Hi, no it has not been resloved yet

[v-pagayam-msft]

Hi @dev99 ,
Thank you fo the follow-up.I would be happy to provide more details on troubleshooting the error you are facing!

1.Ensure the on-premises data gateway is online and updated if applicable. 

2.Verify that the SharePoint URL matches exactly in Power BI Desktop and Power BI Service, and check if the account has the required access permissions.

3.In Power BI Service ,Dataset Settings, edit and re-enter authentication details under Data Source Credentials.

4.Refresh the dataset in Power BI Desktop, save, and re-publish it to the same workspace in Power BI Service.

Please refer the links below:
Troubleshoot gateways - Power BI | Microsoft Learn

Hope this helps,If so kindly mark it as solution.

[v-pagayam-msft]

Hi @dev99 ,
As we have not received a response from you yet, I would like to confirm whether you have successfully resolved the issue or if you require further assistance.If so, please share your solution and mark it as "Accept as Solution." This will assist others in the community who are dealing with similar problems and help them find a solution more quickly.

Thank you.

[v-pagayam-msft]

Hi @dev99 ,
May I ask if you have gotten this issue resolved?
If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

Thank you for being a valued member of the Microsoft Fabric Community Forum!

[v-pagayam-msft]

Hi @dev99 ,
Thank you @lbendlin for your valuable input!

As lbendlin suggested, the credentials (OAuth2 token) in the workspace, if expired or incorrect, may prevent Power BI Service from connecting to the data source.Please check and verify that the authentication method is set correctly.

If this post helps, please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.

Thank you for being a valued member in Microsoft Fabric Community Forum!

[lbendlin]

have you tried refreshing the credentials (the OAuth2 token) in the workspace for that semantic model's connections ?