Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Changing data source with another structure

Hi guys!   I have a Pbix file connected via Direct Query to DataBase "A" (SQL DataBase) . Let's say (to simplify) that DataBase "A" has just a table with 20 columns and just 14 of its colums are u...
Need Help
  • mwegener's avatar
    mwegener
    6 years ago

    Hi Anonymous ,

     

    parameters are also available in direct query mode.

    I recommend to activate this option.

     

    If I answered your question, please mark my post as solution, this will also help others.

    Please give Kudos for support.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thank you for your answer mwegener. 

 

Unfortunately It seems it's not available in DirectQuery mode connection. (It's really interesting for importation mode, though)

mwegener's avatar
mwegener
Most Valuable Professional
6 years ago

Hi Anonymous ,

 

parameters are also available in direct query mode.

I recommend to activate this option.

 

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Priceless help. Thank you, it was just what I needed!

     

    I'm not advanced PowerBI user, trying to improve my skills day after day. Thank you!