Hi, I know there’s a guide to connect a database to PBI and it’s quite straightforward. My question is how to share only some of the tables in the query, because the API Keys enable read, update and delete, but as a whole.
My concern is if I share a read API key only to someone external, how to limit the tables to use in PBI.
At this time there is no way to limit an API key to use only specific tables.
I’ve seen someone recently do something very cool with this by proxying all the API Calls through another script which serves as a middleware. I’ll see if I can track this down later today.