Forum Discussion
PowerQuery Append and DAX Union are not updating data
Hi Rena,
Thanks for your reply.
- The answer to your first question "Is there any error with those 5 identical tables in Power Query Editor?" is No, All of them are working fine and updating without any problem.
- Refreshing Preview Also is working.
- Deleting the appended table and then re-append will fix it as I mentioned before in the topic even if I duplicate or use it as a reference will make it work. But this approach will break all relationships and visuals.
- This Issue happened similarly to Union function in DAX and will work fine if I copy the same formula and make a new table. The original Union refuses to update.
- I haven't tried to revert to an older version and I don't know how. I always download the latest version from MS Store and faced the same issue on two laptops
My current workaround temporary solution, I make all calculated columns and measures on a separate table by referencing the appended table whether it's done by PowerQuery or DAX. Whenever the updating is broken, I just make a new Append and change its reference from the table that contains all columns and measures to break relationships.
Regards
tharunkumarRTK Thanks for your contribution on this thread.
Hi Khalidinho ,
Base on your description, it sounds like you're having trouble with PowerQuery Append not updating data. However, it works before. And you tried the following methods, but still not working.
- Enable the option "Include in report Refresh"
- Clear cache
- Reinstall Power BI Desktop
In order to make further troubleshooting, could you please check and try the following method?
- Is there any error with those 5 identical tables in Power Query Editor?
- Refresh
- Delete the append table then re-append, check if the new append table include the up-to-date data
- Revert the version of Power BI Desktop back to a older version (for examle: March version), and open the pbix file in this older version Power BI Desktop. Later check if it can display the up-to-date data in the append table
Best Regards
Hi Rena,
Thanks for your reply.
- The answer to your first question "Is there any error with those 5 identical tables in Power Query Editor?" is No, All of them are working fine and updating without any problem.
- Refreshing Preview Also is working.
- Deleting the appended table and then re-append will fix it as I mentioned before in the topic even if I duplicate or use it as a reference will make it work. But this approach will break all relationships and visuals.
- This Issue happened similarly to Union function in DAX and will work fine if I copy the same formula and make a new table. The original Union refuses to update.
- I haven't tried to revert to an older version and I don't know how. I always download the latest version from MS Store and faced the same issue on two laptops
My current workaround temporary solution, I make all calculated columns and measures on a separate table by referencing the appended table whether it's done by PowerQuery or DAX. Whenever the updating is broken, I just make a new Append and change its reference from the table that contains all columns and measures to break relationships.
Regards