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,
I'm trying to use a parameter value to specify/equal a table name when connecting to an AzureSQL database through DirectQuery - I feel like this is possible, but my knowledge of the query language is not strong enough to do it!
Any suggestions?
Thanks
Solved! Go to Solution.
There is an example for your reference.
1. Create parameter containing different table names in query editor of Power BI Desktop.
2. Add the parameter to the code in Advanced Editor of your current query.
Regards,
Lydia
There is an example for your reference.
1. Create parameter containing different table names in query editor of Power BI Desktop.
2. Add the parameter to the code in Advanced Editor of your current query.
Regards,
Lydia
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.