Data Source Error when refreshing data in Power BI Service

[tadeom0]

Hello,

I'm getting this error when I tried to refresh my datasets in Power BI 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: https://sharepoint.com/sites/RBITech/RBIPT/Flight/Shared Documents/(WFP)/Flight WFP_xlsx/_api/contextinfo"}},{"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://sharepoint.com/sites/RBITech/RBIPT/Flight/Shared%20Documents/(WFP)/Flight%20WFP_xlsx/_api/co..."}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: TechOpsPlanDataXSquadData.
Cluster URI: WABI-US-EAST2-C-PRIMARY-redirect.analysis.windows.net
Activity ID: baf23729-2acd-4c93-b7b5-88bdee6ab21e
Request ID: 46f6c3be-6743-a4db-2c4f-2b1d6cb05b99
Time: 2025-01-14 15:08:47Z

[v-ssriganesh]

Hi @tadeom0,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[tadeom0]

Unfortunately, my issue has not yet resolved. 

[v-ssriganesh]

Hello @tadeom0 

Greeting for the day.

We are really sorry to hear that the issue has not been resolved, Please click on this Solved: Re: DM_GWPipeline_Gateway_MashupDataAccessError - Microsoft Fabric Community which is related to the issue which your have encountered and helps you solve the issue.

Additionally, please check the below link for your reference: Privacy Levels for Cloud Data Sources | Microsoft Power BI Blog | Microsoft Power BI

If this helps then please Accept it as a solution and dropping a "Kudos" so other members can find it more easily.

Hope this works for you!

Thanks.

[tadeom0]

I asked the admin of the sql server database and he mentioned that if I merge tables from sql server database to an excel file table, this will cause the error message when you refresh it in power bi service. Is any alternative that I can use to merge excel file tables to sql server database?

[v-ssriganesh · Accepted solution]

Hi @tadeom0,

Thank you for your follow-up.

To address the issue you're encountering, you can consider merging the tables directly in SQL Server instead of doing it in Power BI. This can be achieved by creating a new table in SQL Server that combines the data from both the SQL Server database and the Excel file. This approach can help avoid the refresh error in Power BI Service.

If you need further assistance or have any more questions, feel free to ask. If this solution works for you, please mark it as accepted and give it a "Kudos" so other members can benefit from it.

Thank you.

[v-ssriganesh]

Hi @tadeom0 ,

Thank you for reaching out to the community forum.

I understand that you're encountering a "Data Source Error" when trying to refresh your datasets in Power BI Service. Based on the error details you provided; it seems that the issue is related to accessing a SharePoint file.

Here are a few steps you can try to resolve this issue:

• Even if you have access to SharePoint, there might be restrictions on certain files or folders. Please double-check that the credentials used for the SharePoint data source are correct and have not expired. You can update the credentials in the Power BI Service under the dataset settings. Additionally, try accessing the SharePoint file directly through a web browser to ensure that the file is accessible and there are no network issues.
• If you are using an On-Premises Data Gateway, make sure it is up-to-date and properly configured. You can try restarting the gateway to see if that resolves the issue.
• Since you mentioned that there are no errors in each applied step, it might be helpful to review the steps again to ensure there are no hidden issues. Sometimes, minor changes in the data source can cause refresh errors.

If this helps, then please Accept it as a solution and dropping a "Kudos" so other members can find it more easily.
Thank you.

[SaiTejaTalasila]

Hi @tadeom0 ,

Go to semantic model settings>credentials -update your credentials>Oauth2 and organizational.If it is not working downloaded your report and turn on column quality in transform data and check your applied steps for any errors in the following table TechOpsPlanDataXSquadData.

Thanks,

Sai Teja 

[tadeom0]

I already updated my credentials and also turned on column quality to check for any errors but there are no errors in each applied steps. 

[tadeom0]

Yes, I have access to the SharePoint file

[GilbertQ]

Hi @tadeom0 

Could you please confirm that you still have access to the sharepoint site? and the Sharepoint file?

[tadeom0]

I have access to the SharePoint site and SharePoint files