March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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?
I don’t think it is possible. To make customers only see specific data, we can use RLS to control it.
Best Regards,
Herbert
User | Count |
---|---|
117 | |
77 | |
58 | |
52 | |
46 |
User | Count |
---|---|
171 | |
117 | |
63 | |
57 | |
51 |