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...
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
Thanks Greg. So how can you tell what sql database your connected too?
- You typically you would go into Power Query and either use the Advanced Editor or you use the gear icon in the Source step.
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