Forum Discussion
Helper IUse parameter to change data connection types (e.g. Denodo to SQL Server)
Hi angeloola ,
Based on my test, you could refer to below code in query editor with if parameters:
With my sample, I uesed two excel files, you could switch one to your sql query.
Regards,
Daniel He
Microsoft EmployeeHi angeloola ,
You could refer to below blog about how to switch the datasource for your data model:
https://biinsight.com/power-bi-desktop-query-parameters-part-1/
Regards,
Daniel He
Helper IThanks, sure I found that one. It's only toggling between two different instances of a SQL Server connection. I'm looking at how I could possibly toggle the connection TYPE (e.g. from a SQL connection to a Denodo or Excel). If you know of any examples of this I'd love to see them.
I spent a lot of time on this forum looking for and answer because there's loads of great solutions here. I wasn't able to find a solution for my specific problem... Any other suggestions would be much appreciated. At this point I'm still stuck on this one.
-A
- v-danhe-msft
Hi angeloola ,
Based on my test, you could refer to below code in query editor with if parameters:
With my sample, I uesed two excel files, you could switch one to your sql query.
Regards,
Daniel He