Forum Discussion

Ravindra_'s avatar
Ravindra_
Frequent Visitor
1 year ago
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...
Need Help
  • v-ssriganesh's avatar
    v-ssriganesh
    1 year ago

    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.

v-ssriganesh's avatar
v-ssriganesh
Community Support
1 year ago

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.