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.

az38's avatar
az38
Community Champion
6 years ago

Hi Anonymous 

why dont you just describe only these useful 14 fields in the SELECT..from SQL-statement?

 

do not hesitate to give a kudo to useful posts and mark solutions as solution