Forum Discussion
Not being able to view data from synapse, while having the correct permissions
I am running a serverless SQL pool but for some reason I cannot run select statements on it or collect data from it using PowerBI. This is the error code I receive:
External table '---' is not accessible because location does not exist or it is used by another process.
When the owner tries to do it, it works fine but now with contributor permission over the entire resource it doesnt work for me, could anyone help me here?
5 Replies
Thank you, this worked! Weird how synapse permissions work then
This is really a synapse and data storage issue not Power BI. Usually, if using a sql serverless pool, the data is in a Azure Data Storage (ADSL) Account Gen 2. Synapse if creating a 'table' (virtually) over the file data in ADSL (csv or parquet). The permissions required are at the ADSL plus access to Synapse.
Usually it is the Storage Blob Data Reader needed on the storage account level for Power BI to read the data through a sql serverless table.
They are being read from a parquet file, wont general contributor come with these permissions tho?
