Forum Discussion
Data Source Power BI
Hi zameenakarmali ,
Thanks for the clarification.
The reason you are seeing duplicate tables and multiple relationships with Dim_Date is because each of your files is being loaded as a separate query. To avoid this, instead of connecting to each file, you can connect to the parent folder and append all files into a single fact table in Power Query. While doing this you can add a custom column to identify whether the data came from the weekly, monthly, or live folder. This way you only need one relationship to Dim_Date, and you can use that new column in your report to switch between weekly, monthly, and live views.
Here is the documentation on combining files from a folder: Combine files (binaries) in Power BI Desktop - Power BI | Microsoft Learn
You may also find it useful to check these similar community discussions that go through the same type of scenario:Solved: Power BI: How to Combine Multiple Excel Files from... - Microsoft Fabric Community
Solved: Correct way to append/merge data files - Microsoft Fabric Community
Solved: How to bring in multiple excel files once availabl... - Microsoft Fabric Community
Hope this helps. Please reach out for further assistance.
Thank you.
Also thanks to Mauro89 and srlabhe for addressing this earlier and for valuable guidance.
Hi zameenakarmali ,
Just wanted to check if the response provided was helpful. If further assistance is needed, please reach out.
Thank you.
Hi zameenakarmali,
I thinks that's already a ok solution. If you have all your sales data in a single file and want to create the weekly an monthly extract of it you can also go the Power Query way to create new tables out of it.
Best regards.
Yes but the only is then Is I have duplicate tables and relationships between each of the table and the Dim_Date table
Hi zameenakarmali ,
Thanks for the clarification.
The reason you are seeing duplicate tables and multiple relationships with Dim_Date is because each of your files is being loaded as a separate query. To avoid this, instead of connecting to each file, you can connect to the parent folder and append all files into a single fact table in Power Query. While doing this you can add a custom column to identify whether the data came from the weekly, monthly, or live folder. This way you only need one relationship to Dim_Date, and you can use that new column in your report to switch between weekly, monthly, and live views.
Here is the documentation on combining files from a folder: Combine files (binaries) in Power BI Desktop - Power BI | Microsoft Learn
You may also find it useful to check these similar community discussions that go through the same type of scenario:Solved: Power BI: How to Combine Multiple Excel Files from... - Microsoft Fabric Community
Solved: Correct way to append/merge data files - Microsoft Fabric Community
Solved: How to bring in multiple excel files once availabl... - Microsoft Fabric Community
Hope this helps. Please reach out for further assistance.
Thank you.
Also thanks to Mauro89 and srlabhe for addressing this earlier and for valuable guidance.
Hi zameenakarmali ,
Just wanted to check if the response provided was helpful. If further assistance is needed, please reach out.
Thank you.