Using a paramater value as a table name when connecting to AzureSQL via DirectQuery

[JDLee23]

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

[v-yuezhe-msft · Accepted solution]

@JDLee23,

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