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.