Change the Source Database connection using DAX

[Anonymous]

Hello Team

I am doing some testing using a Business Central Sandbox environment. Is there somehwere I can change the database source to be Production without using the UI? As in is there some DAX code I can see to confirm where the data source is coming from so I can quickly and easily swap or move the data source?

To be clear the database in an Online Service from Microsoft called Business Central.

Thank you

[Greg_Deckler]

@Anonymous - Not yet but people usually use Power Query parameters for this purpose. I believe there was a feature announcement at MBAS that might fit the bill for what you want but I may be mistaken. https://docs.microsoft.com/en-us/power-platform-release-plan/2020wave1/business-intelligence/planned-features

[Anonymous]

Thanks Greg. So how can you tell what sql database your connected too?

[Greg_Deckler]

You typically you would go into Power Query and either use the Advanced Editor or you use the gear icon in the Source step.

[Anonymous]

HI Greg

I must be missing something. Can you share what screen you would update the datasets. I dont seem to have this option.

Thank you for helping