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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

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
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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