Forum Discussion

santhiya's avatar
santhiya
Helper I
3 years ago

Problems in Connection With Production Database

Hi Community !!!

I am not using any Datawarehouse as Datasource, Instead connecting my Production replica. The reason is there are some relationship mismatch and Schema changes . Will There be any issues in future by following this approach.

Thanks in Advance

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi santhiya ,

    If I understand correctly, you connect to the production environment data source directly due to the difference of relationship and schema between staging environment and production environment. And you want to know if it will cause any "issue" in the future. Am I right? If yes,  I'm not sure what the issue means? The visual will not display the data normally or something else? Could you please explain more details on it? Thank you.

     

    You can refer the following blog to change the data source dynamically.

    Change the Source of Power BI Datasets Dynamically Using Power Query Parameters - RADACAD

    Best Regards