Forum Discussion

JDLee23's avatar
JDLee23
Helper I
8 years ago
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 language is not strong enough to do it!

 

Any suggestions?

 

Thanks

Interesting Links
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    8 years ago

    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

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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