Forum Discussion
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 be identical. Then I append these 2 tables as new and I name the new table , table C. So, I have created this new table ( table C ) where I can see for example the net daily sales (invoices minus credit statements). This is happening in my Power BI desktop and then I publish the report so others can see it through the Power BI service.
Today I realized that the report in power BI service shows data only from yesterday and it doesnt show data from the current date... This issue is resolved only if I go back to Power BI desktop and press refresh. Normally, the power BI service should work without having to open power bi desktop again and press refresh...right?
Any idea why is this happening?
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!
3 Replies
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.
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!
