Forum Discussion

gastonguy's avatar
gastonguy
Frequent Visitor
10 years ago
Solved

Different data according to user credentials

I want to share a dashboard that I will design. But I want that every users who will access it see different data, according to their credentials. I understood that I can define a Row-Level Security ...
Need Help
  • Anonymous's avatar
    Anonymous
    10 years ago

    Hello gastonguy

     

    I don't know yet how Microsoft will implement the Row Level Security, but if is the same as SSAS, it will be based on AD user / group.

     

    When you use a gateway between powerbi Services and the data server, you configure it with your credential, that's ok, but when other users will use your reports and see the data, the gateway will pass the user login as Effectivename. This property will be check againts AD and the role to retrieve the only data they can see.

    This works pretty well with SSAS, so I may be the same way with Sql Server 2016, but you have to use Live Query, it won't work if you import the data model, there is no security in it.

     

    Sebastien

gastonguy's avatar
gastonguy
Frequent Visitor
10 years ago

Thank you very much.

And doing like this, do you know if I still can integrate the Dashboard or Report inside another private application (using the Power BI REST API)?

Anonymous's avatar
Anonymous
Not applicable
10 years ago

You can use REST API with Power BI, to get your doashboards, tiles and reports list. So I guess that you will be able to get the report, becaues when you're connected to Power BI using REST API, you have to be authenticated with your Power BI account, so there should no be different than when you're directly connected.

 

But, even if I managed to list my dashboards, tiles and reports, I didn't see the REST API call to get the Reports. For information, you can check the doc here (I think you already know it) : Power BI REST API Reference

 

Sebastien