Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi
From a workspace, if I choose New > Dataflow > Define New Entities > ODBC
Is there anyway to reference the Data Source Name defined on the gateway instead of the connection string each time?
Even if this can only be changed in the Advanced Editor, I would love to know how.
Thanks in advance.
Oli
Solved! Go to Solution.
Hi @music43
To my knowledge, this is currently not possible to achieve. If this could be achieved, something like parameters storing connection strings should be passed between gateway and dataflow, but there is no such connection now.
I think it's an interesting idea. If realized, it will simplify the settings and reduce repeated operations a lot. You may raise an idea about this at https://ideas.powerbi.com/ideas/
Regards,
Community Support Team _ Jing
Hi @music43
To my knowledge, this is currently not possible to achieve. If this could be achieved, something like parameters storing connection strings should be passed between gateway and dataflow, but there is no such connection now.
I think it's an interesting idea. If realized, it will simplify the settings and reduce repeated operations a lot. You may raise an idea about this at https://ideas.powerbi.com/ideas/
Regards,
Community Support Team _ Jing
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.