Forum Discussion
Change the Source Database connection using DAX
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
4 Replies
- 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
- You typically you would go into Power Query and either use the Advanced Editor or you use the gear icon in the Source step.
