Forum Discussion
Solved
Using a paramater value as a table name when connecting to AzureSQL via DirectQuery
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 lan...
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