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.

v-alq-msft's avatar
v-alq-msft
Community Support
6 years ago

Hi, Anonymous 

 

It's possible to switch a model from DirectQuery mode to use import mode, all the necessary data must be imported. While it's not possible to switch back, primarily because of the set of features not supported in DirectQuery mode.

 

You may click the 'Storage Mode' in the bottom left of Power BI Desktop to switch a model from DirectQuery mode to use import mode. Or you may change the mode in 'Model View'.

 

 

Best Regards

Allan

 

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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hey v-alq-msft !

Thanks for trying to help, but this was not the thing I was seeking solution for. I'm aware that I can change DQ to import from storage-mode tool. I meant that when DQ table is in the model, can I directly refer it as an import table, without need to refresh import-table from SQL server but directly from DQ.
I'd like to know if it's possible to get import-table contents updated as DQ -table updates without need to manually refresh Import-table?
Once again, thanks for answering!

  • v-alq-msft's avatar
    v-alq-msft
    Community Support
    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.

  • artemus's avatar
    artemus
    Microsoft Employee
    6 years ago

    You can probably achieve this by adding a power apps visual, which can update the underlying Power Bi data model