Forum Discussion

Kergofil's avatar
Kergofil
Regular Visitor
5 years ago
Solved

Direct Query - Append tables

Hello,    I have table A and table B from SQL server and I am using direct query with Power BI. Then I customize these two tables to have the same columns and name columns , so these two tables can...
Need Help
  • Kergofil's avatar
    Kergofil
    5 years ago

    Thank you for your prompt reply and my apologies for replying back late. Indeed, I noticed that if I schedule refresh data for specific time slots then the data is up to date. Thanks again for your help!

edhans's avatar
edhans
Icon for Community Champion rankCommunity Champion
5 years ago

Power BI doesn't support Direct Query for appended tables. It will silently convert that query to Import. Go to the Model View and hover over that query and it will say Import. If you have any other tables in the model that are still Direct Query, your storage mode in the lower right corner of the Report View will say mixed.

You can merge in DQ, but you cannot append. You must set up a scheduled refresh to get those tables to be refreshed in the model.

  • Kergofil's avatar
    Kergofil
    Regular Visitor
    5 years ago

    Thank you for your prompt reply and my apologies for replying back late. Indeed, I noticed that if I schedule refresh data for specific time slots then the data is up to date. Thanks again for your help!