Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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?
Solved! Go to Solution.
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!
I am working on a project where the data gets refreshed every 6hours, I also need the append to update and it all to be live has anyone got any ideas?
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.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingThank 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!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
14 | |
13 | |
12 | |
12 | |
12 |