Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Exposing a View on Azure Table Storage via Power BI Dashboard

We currently have a mobile app that reads and writes data to Azure Table Storage via an Azure Function

 

We allow a single partner to access all that data via a Power BI Dashboard as per the mobile app user's T&C.

 

We need to bring on another 10+ partners and offer them the same view of the data via a Power BI dashboard.

 

However it is within the user's control as to which of these partners they want to share their data with. Therefore the PowerBI dashbaord cannot simply point at all the datas for all users. We would maintain that relation in an Azure Table that has User Id to Partner Id mappings. 

 

  1. Is it is possible to filter the data this way rather than just pointing directly at the Azure Table Storage and therefore exposing all the data?
  2. Once a dashboard is created and then shared with a Partner company can they open that dashboard and edit the query that controls what data is applied?

I appreciate this is really Power BI 101 and I am trying to get rapidly up to speed on Power BI myself but at this stage it would be great to get some high level Yes or No to these questions.

 

Thanks

 

 

 

Data Protection
Need Help

1 Reply

  • artemus's avatar
    artemus
    Microsoft Employee
    6 years ago

    1. Yes, if you are using Direct Query, you can apply your own filtering rules. Use Extension.CurrentCredential to determine who is currrently running the query (and make sure they are authenticated). You can use a not-loaded-to-model query if you want the engineer who is deploying changes to enter in the auth for the Azure tables, Then your data connector is simply a filter.

     

    Actuallly, just don't use a custom connector. Use Row level security: https://docs.microsoft.com/en-us/power-bi/service-admin-rls

     

    2. No, if you aren't on the workspace you cannot edit the query (which you can do by downloading the pbix), but you can use all fields used by the dataset and make your own visuals.