Forum Discussion
Pass data source credentials in Power BI as parameters
You can create custom connector with authentication type as "UsernamePassword"
Here are some links which may help you
Authentication Handling: Handling authentication for Power Query connectors - Power Query | Microsoft Learn
Creating simple custom connector: Create custom connectors in Power Bi - YouTube
Dhairya thanks for the reply.
This is for Azure sql as a data source.
Could you please share any sample power bi file which has these power query connectors implemented.
Please help.
Here is the official github repo of microsoft here you can find stepwise implementation of custom connectors and there are some connectors present in sample folder
https://github.com/microsoft/DataConnectors
You can refer this one also and modify your connector as per your requirements.
https://www.progress.com/tutorials/odata/connect-to-odata-from-power-bi-using-oauth2-authentication