Solved: RLS for BW

fapel · ‎02-08-2017

Will Row-level security(RLS) work for SAP BW connections? Can these reports be published and refreshed using the Enterprise gateway?

v-qiuyu-msft · ‎02-09-2017

Hi @fapel,

It's able to use the RLS feature for the SAP BW data source. See: Limitations

"Only ETL, and DirectQuery connections are supported. Live connections to Analysis Services are handled in the on-premises model."

We can also configure the SAP BW to use on-premise data gateway and set schedule refresh. See: List of available data source types.

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

v-qiuyu-msft · ‎02-09-2017

Hi @fapel,

It's able to use the RLS feature for the SAP BW data source. See: Limitations

"Only ETL, and DirectQuery connections are supported. Live connections to Analysis Services are handled in the on-premises model."

We can also configure the SAP BW to use on-premise data gateway and set schedule refresh. See: List of available data source types.

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.