Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Possibility to make import table from Direct Query-table without calling SQL server?

Hey! I have one project I'm working on which requires quick refresh. I got one table that I'd like to get with DIrect Query but I also need to make deductive columns from that data. Thats why I need...
Need Help
  • v-alq-msft's avatar
    v-alq-msft
    6 years ago

    Hi, Anonymous 

     

    Unfortunately, It is unsupported to get import-table contents updated as DQ -table updates without need to manually refresh Import-table. For import mode, you need to click the 'Refresh' buttton in Power BI Desktop, configure schedule refresh or click 'Refresh now' in Power BI Service to update data.

     

    Best Regards

    Allan

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Mariusz's avatar
Mariusz
Community Champion
6 years ago

Hi Anonymous 

 

Nor sure if I fully understand what you need but, you can reference the DQ table in Power Query and change it to import mode or just switch the original table to import.

 

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn