Forum Discussion
Using Paramters to define ODBC connection
Hi, Wondering if there's a way to use a parameter to define the ODBC Data source. I want to connect via CData's ODBC driver for Xero. This provides access to multiple tables via SQL statements. I...
Since this Power BI question is now in the Fabric community, how would one do this with a Fabric Dataflow Gen 2?
When I try, it works like above with a foreach-loop, but when publishing it fails with the error
Dynamic datasources are not supported