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.

mwegener's avatar
mwegener
Most Valuable Professional
6 years ago

Hi Anonymous ,

 

I always change the connection string in the Power Query editor.

We have parameterized them in our templates.

To reduce the points of change, I use the "One Data Source" approach.

https://powerpivotpro.com/2017/05/power-query-magic-part-1-always-good-references/

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!