Wondered if anyone can help with the following scenario:
Added our on-premise SAP BW as a data source to our on-premise data gateway (connectivity is successful)
Imported data from SAP BW to PBI desktop, publish to service
Report and data appear fine in PowerBI.com
After manual or scheduled refresh, the visuals are empty of data, i.e. the data disappears and the visuals contain no data. I can still see the tables in the dataset, but there are no values when adding columns to a visual.
There is clearly a problem with the refresh through the gateway, i.e. there is connectivity but no data.
Can anyone confirm what specific permissions the gateway credentials need to have in BW to get the data? For example, to connect and retrieve data from SQL Server, the gateway user requires server admin permissions. Is it the same with BW?
>>For example, to connect and retrieve data from SQL Server, the gateway user requires server admin permissions.I think the issue is not caused by the permission, if your connection is active it means you already have the enough permission to operate the datasource.
In addition, you can try below methods to ensure the issue.
1. Check if issue is related to datasource.
Re-create a datasource and test again.
2. Check if the issue is related to gateway/database.
Add a new type database to test.
3. Check if the issue is related to network connection. Change a stable network to test.
Community Support Team _ Xiaoxin Sheng If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
For learning resources/Release notes, please visit: | |