Gateway accessing web/sharepoint

[Squairyy]

Hi, 

I am facing a following error when trying to refresh dataset in Service. It works fine on desktop:

• 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":"Web: Request failed: [HERE IS A LINK TO FILE ON SHAREPOINT]/_api/contextinfo"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"Web"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":" [HERE IS A LINK TO FILE ON SHAREPOINT]/_api/contextinfo"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: Final Table (3).
• Cluster URIWABI-WEST-US-C-PRIMARY-redirect.analysis.windows.net
• Activity IDd2d44219-5acc-4c73-9c35-2428cd8be015
• Request ID0c48801a-742a-fe83-f0f1-41fa65248511
• Time2024-12-01 14:52:41Z

  Copy
  
  

  When connecting to that data source as a seperate dataset, it works okay, no error in refresh.
  Gateway configured correctly, 

  

  All credentials are setup as organizational both in web as in desktop.
  I think I've already tried everything and just cannot locate issue, error message is also not helpful.

[Anonymous]

Hi, @Squairyy 

Have you solved your problem? If not resolved, you can refer to the following links hopefully it will help you.

Refresh a Power BI Desktop File (pbix file) from OneDrive or SharePoint Online - Power BI | Microsof...

Troubleshoot gateways - Power BI | Microsoft Learn

Troubleshoot Power BI gateway (personal mode) - Power BI | Microsoft Learn

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[collinq]

HI @Squairyy ,

I am wondering if you would look at the one that works and the one that you have and compare the difference.  I see that they are both "organizational" but do you have the same permission type (basic vs oauth) in the one that works and the one that does not.  Also, is this the exact same data source in the gateway?  Also, are you using the EXACT same link in both the Desktop and the Service.  (To confirm look at every character to confirm - not just that they look alike, I have been burned by this in the past.)