Forum Discussion
Solved
How to Save Custom Connector Credential/Connections into a Local Database(Read/Write) in PowerQuery
Hi everyone, I’m developing a Power BI custom connector using Power Query SDK and I need to store the user’s connection configurations (Service URL, Username, Password, Connection Notes, etc.) insid...
Hi manandhu
PQ can't INSERT/UPDATE/DELETE through a connector.
To read existign connections you can use Extension.CurrentCredential()
Handling authentication for Power Query connectors - Power Query | Microsoft Learn
In your connector you can use things like DataSource.Kind and DataSource.Path which are saved in the PBIX or Service.
Using a Data source path for Power Query connectors - Power Query | Microsoft Learn
Phil
Hi manandhu ,
Thank you PhilipTreacy for your inputs.
Just following up to see if the Response provided by community members were helpful in addressing the issue. if the issue still persists Feel free to reach out if you need any further clarification or assistance.
Best regards,
Chaithra E.