Forum Discussion
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
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.
3 Replies
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!!!
.csv file I get from a power automate get data from a power bi reportHave you considered directly running that query against the originating semantic model ?
