Forum Discussion
Gateway accessing web/sharepoint
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.
2 Replies
- collinqSuper User
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.)
- AnonymousNot applicable
Hi, Squairyy
Have you solved your problem? If not resolved, you can refer to the following links hopefully it will help you.
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.