Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Solved! Go to Solution.
Hi,
many thanks for the response!
I have actually tried another approach - where I have selected the columns which will always be the same ( I mean in the new raw data their value wont change) and having all those selected columns Right click and Remove duplicated - this seems to be doing the job just fine for now 🙂
Best regards,
Ivan
Hi @IPGeorgiev ,
Despite the validity of what @MattAllington suggested for detaching and storing reports using MS Flow, I guess mentioning MS Exchange in your post to me looks a bit remote to the problem you have. This relates to the file/data that you receive, not to sourcing it from Exchange server, right?
In the file, the problem is not that some data change over time, as this is surely controlled from somewhere else and not impacted by PBI, You need somehow update these "new" data against some global table/storage so that it would contain the most recent version of the data in the columns that have changed? Kind of incremental data update?
If my understanding correct, you can use Table.NestedJoin (i.e.. merge tables) to get the set of data for Date / CaseId combinations in the old/stored data that also present in the new/14 day data in the file. Remove the identified data from the main table/storage and then append new data from the file.
Hope this helps, otherwise, you may need to further explain your case :).
Kind regards,
JB
Hi,
many thanks for the response!
I have actually tried another approach - where I have selected the columns which will always be the same ( I mean in the new raw data their value wont change) and having all those selected columns Right click and Remove duplicated - this seems to be doing the job just fine for now 🙂
Best regards,
Ivan
Have you considered Power Flow as the tool here? You can get flow to wait for the email, detach the file and then trigger the refresh of Power BI
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.