PBI - Hana conecction with restrictions

[SANDRALIA]

Hi friends! 

We are using SAP Hana for HR (HCM) area.  We need read some data, but some other data should not be available (restricted) even for PBI.

Is possible to do a conecction PBI - Hana restrincting the model available to read ?

Thanks in advance!

[SANDRALIA]

HI @Anonymous , Thanks for your answer.    
I agree with you about Hana connections.   Is this case, some part of the data in Hana model is confidential,  then we need a Hana connection "restricted" only to some schemes/models, and not be able to see the rest of the data.
Thanks in advance!

v-rzhou-msft

[Anonymous]

Hi @SANDRALIA ,

As far as I know, Power BI support us to connect to SAP HANA database by connector directly.

I think you may refer to below offical blog to learn more details about prerequisites and how to connect to an SAP HANA database from Power Query Desktop.

For reference:

SAP HANA database

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.