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

[hihi]

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

[StrategicSavvy · Accepted solution]

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.

[lbendlin]

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]

.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 ?