Don't miss your chance to take the Fabric Data Engineer (DP-700) exam on us!
Learn moreWe've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. Register now
Hi,
We are trying to use dataflows to load monthly excel files (from Sharepoint folder) into Power BI datamart.
We have the below setup and have tried the below approach..
Scenario -
1.) We have a historic data load populated using a Dataflow and pulled as a table in datamart (SalesHistoric)
----this is working fine as expected
2) Latest month data load file will be available in a shared folder in Sharepoint Online (example Sales-Jan2023)
----for this we need to create a new dataflow which will always read the data file available from the sharepoint folder (this case it is sales data of Jan 2023) We are planning to keep only data for latest month in this folder (so sales data of Jan 2023 will be overwritten with the sales data of Feb 2023 next month).
We need to ensure that the dataflow loads the data for Jan 2023 in the datamart table for this month and continue to append (future months data) to it.
This table will then be appended to the Historic sales data table to come up with All Sales data.
Does anyone have any idea or link or pointers as to how this can be achieved ?
Any suggestions would be highly appreciated.
Thanks.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.