Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi everybody,
I`ve been on this all week and I`m starting to go crazy...
the current model i´m working on uses the following datasources:
- SAP HANA (on prem)
- Excelfiles stored in sharepoint (online / cloud) and connected to the dataset via the web connector
I`m using a gateway (Dez 2020 Version) that has the HANA credentials. I activated the "Allow user's cloud data sources to refresh through this gateway cluster" option and entered my Sharepoint credentials.
There are a lot of different files that get appended onto the SAP HANA Table (just a regular join in Power Query).
The refresh in PBI Desktop works just fine, in the PBI Service however it does not:
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://URLTOEXCELFILE1234/_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://URLTOEXCELFILE1234/_api/contextinfo"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: Master.
Cluster URI:WABI-EUROPE-NORTH-B-redirect.analysis.windows.net
Activity ID:e30704a7-2ac3-4411-91ad-c1056ef9b92e
Request ID:1087f8c5-3a98-cf0a-7633-3fe1853184b8
Time:2021-01-20 16:56:04Z
I already figured out that the error has to be somewhere in the append of the Sharepoint files onto the HANA Table. Whenever I upload just the HANA Views or just the sharepoint Excel files the refresh works. The error message always shows the first Excel file that is supposed to be appended to the HANA View so it has nothing to do with a specific file.
I already tried:
- Setting Datasource settings to private, Corporate and none (in PBI Desktop as well as the service)
- Activate "always ignore data security" under Data security
- Split the joins that all SAP HANA Tables are joined first and then append all other tables
Maybe some of you Power BI gods have the answer I am looking for 😄
Best regards
Timo
I see there has been an update to the December release of the gateway, can you check you have that latest version installed?
**We recently fixed a bug in the December release and have updated the release to version 3000.68.15**
Hi Nicky,
thanks for your response and sorry for the late reply. Updating the gateway took a while...
Unfortunately that does not fix the error message, I still get the same one with the newest Gateway version.
Best regards
Timo
Hi @T4S3R ,
then I'd suggest opening a support ticket, which is free if you have a Pro license. Go to the support page to file a support ticket.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.