Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
hihi
Frequent Visitor

Refresh error when combine data between sap hana and sharepoint .csv file.

Hi Guys, 

I have a report with 2 data sources, one SAP Hana DB, and the other is reading from .csv file from my one drive(from link SharePoint). I set their privacy is organization ( in same privacy). with .csv file I get from a power automate get data from a power bi report (like this: https://www.youtube.com/watch?v=BsXZUaarFWM&t=191s
my issue is when I join 2 tables of 2 sources and refresh data in PBI Desktop it's Ok. But, when I publish to pbi service and refresh I have a message like this: 

{"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":"We're sorry, an error occurred during evaluation."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}}],"exceptionCulprit":1}}} Table: slsx

1 ACCEPTED SOLUTION
StrategicSavvy
Resolver II
Resolver II

hi @hihi 

 

I remember troubleshooting joined tables where one was on prem and the other on in the cloud and I would recommend to aviod join and establish relationship within DAX instead if possible. 

 

I think it didnt specifficaly helps but if you can afford it should work.

View solution in original post

3 REPLIES 3
StrategicSavvy
Resolver II
Resolver II

hi @hihi 

 

I remember troubleshooting joined tables where one was on prem and the other on in the cloud and I would recommend to aviod join and establish relationship within DAX instead if possible. 

 

I think it didnt specifficaly helps but if you can afford it should work.

If you merge a cloud data source with an on-premise data source then the cloud data source will also require a gateway - and will continue to even after you eliminate the on-prem source!!!

lbendlin
Super User
Super User

.csv file I get from a power automate get data from a power bi report

Have you considered directly running that query against the originating semantic model ?

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Kudoed Authors