Forum Discussion

hihi's avatar
hihi
Frequent Visitor
2 years ago
Solved

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...
Need Help
  • StrategicSavvy's avatar
    StrategicSavvy
    2 years ago

    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's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago
.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 ?