Problems in Connection With Production Database

[santhiya]

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

[Anonymous]

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