topic Change the Source Database connection using DAX in DAX Commands and Tips

Change the Source Database connection using DAX

Anonymous — Sun, 24 May 2020 10:38:12 GMT

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

Re: Change the Source Database connection using DAX

Greg_Deckler — Sun, 24 May 2020 10:46:25 GMT

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

Re: Change the Source Database connection using DAX

Anonymous — Sun, 24 May 2020 10:49:08 GMT

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

Re: Change the Source Database connection using DAX

Greg_Deckler — Sun, 24 May 2020 11:30:35 GMT

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

Re: Change the Source Database connection using DAX

Anonymous — Mon, 25 May 2020 00:14:53 GMT

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