I`ve been on this all week and I`m starting to go crazy...
the current model i´m working on uses the following datasources:
- SAP HANA (on prem)
- Excelfiles stored in sharepoint (online / cloud) and connected to the dataset via the web connector
I`m using a gateway (newest Version) that has the HANA credentials. I activated the "Allow user's cloud data sources to refresh through this gateway cluster" option and entered my Sharepoint credentials.
There are a lot of different files that get appended onto the SAP HANA Table (just a regular join in Power Query).
The refresh in PBI Desktop works just fine, in the PBI Service however it does not:
I already figured out that the error has to be somewhere in the append of the Sharepoint files onto the HANA Queries. Whenever I upload just the HANA Views or just the sharepoint Excel files the refresh works. The error message always shows the first Excel file that is supposed to be appended to the HANA View so it has nothing to do with a specific file.
I already tried:
- Setting Datasource settings to private, Corporate and none (in PBI Desktop as well as the service)
- Activate "always ignore data security" under Data security
- Split the joins that all SAP HANA Tables are joined first and then append all other tables
For all its worth, here are all Query statements in the file, the error points to the Master Table: