Forum Discussion
Solved
Environment Switching in Power BI Custom Connector Using M language(Staging <-> Production)
Hi Team, I’m developing a Power BI Custom Connector and would like to implement a mechanism to switch between Staging and Production environments dynamically. Is it possible to design a build where...
Hi Ravindra_,
Thank you for reaching out to the Microsoft Fabric Forum Community.For your scenario implementing environment switching in a Power BI Custom Connector the recommended best practice is to use user-defined parameters via the connector UI. This approach ensures:
- Compatibility with both Power BI Desktop and Power BI Service
- Compliance with security and sandbox restrictions
- Flexibility to scale across different environments without hardcoding or relying on local files
If this information is helpful, please “Accept it as a solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
Thank you.
Why not just use parameters to swap connection string or schema like you would with other connectors?