Forum Discussion
CredentialMissing for SQL kind inside Custom Connector
That's what RLS is for?
If ms_query ,
If you want to limit some access based on each user, you can use RLS and OLS for this as lbendlin suggested.
Initally connect using the standard connection using the SQL user name password. Then setup the Ro level Security and share with users accordingly.
You even can use the Object level Security filtering some part of the tables with specific user group.
If you have a larger yser list, you may bring the same users to the model and setup a dynamic RLS where each user filers the specific rows accordingly
Thanks SacheeTh for the reply.
Yes I have Authentication setup in my extension as you suggested. But it fails while evaluteing ms_test_ext.query.pq itself.
as if it could not find the credentials for
Resolver IITyr Modify your as follow, pass both the server and databas
let
result = ms_test_ext.Contents("myserver-ondemand.sql.azuresynapse.net", "mydatabase")
in
result
Not much of an indea since your one is a custom connector, asuming this is done using power m query, I can suggest following as well,
Ensure the DataSourcePath matches what the SQL source (myserver-ondemand.sql.azuresynapse.net) expects. This includes both the server name and the database name.
The CredentialMissing error often happens when the SQL credentials are not propagated correctly from the custom connector.
You're passing only the server URL, but SQL often requires both server and database names explicitly. Adjust the connector to expect both parameters.
Additional Steps
- Clear existing credentials from Data Source Settings in Power BI.
Is it possible for you to try with any of your SQL server connection to confirm. As nothing is working for me.