Forum Discussion

r_beacroft's avatar
r_beacroft
Frequent Visitor
9 years ago

OData Feed source, authentication to be driven by table drilldown

We have an OData feed. Logins for a customer to the OData feed result in a connection to the customer's (isolated) database to retrieve their data. We would like the ability to be able to manage this by having a table list all customers, and drill down into a customer to drive the OData authentication and thus pull customer specific data via a direct query call.
Is this possible?

APIS and Embedding

2 Replies

  • v-haibl-msft's avatar
    v-haibl-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    r_beacroft

     

    I don’t think it is possible. To make customers only see specific data, we can use RLS to control it.

     

    Best Regards,

    Herbert

    • r_beacroft's avatar
      r_beacroft
      Frequent Visitor
      9 years ago
      That's a shame. If Power BI could enable one to filter a result and have that drive a multi-level drill down across pages, THEN it would really be a valuable tool!