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!