Forum Discussion

Khalidinho's avatar
Khalidinho
Frequent Visitor
2 years ago
Solved

PowerQuery Append and DAX Union are not updating data

Hello,   I have 5 identical tables but different categories and teams in Excel. When I Import them, They update normally when refreshing and all data are up-to-date. However, My problem is when I c...
Need Help
  • Khalidinho's avatar
    Khalidinho
    2 years ago

    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

Khalidinho's avatar
Khalidinho
Frequent Visitor
2 years ago

Hi tharunkumarRTK, It's already enabled

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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

  • Khalidinho's avatar
    Khalidinho
    Frequent Visitor
    2 years ago

    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