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.

StrategicSavvy's avatar
StrategicSavvy
Icon for Resolver II rankResolver II
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

    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!!!