Question about connecting the data from 2 Files

[Nivram]

Hello Power BI Community,

I have a question that I'm sure the experts among you can answer without further problems.

I have included 2 Excel files as data source in the dataset. Excel A for 2022, Excel B for 2023.

How can I link the Excel files so that in a visual (eg bar chart) the data from Excel A with the data from Excel B is continued?

Thanks for your help 🙂

[v-jingzhang]

Hi @Nivram 

To display two Excel files' data in a visual continuously, you need to combine data from two files into one table first. Append queries is a good method to do that. Before appending, ensure that the column headers have the same names for columns that share the same meaning. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it. Highly appreciate your Kudos!

[Idrissshatila · Accepted solution]

Hello,

you can insert both files into power bi and in power Query you can append both files to have it as one dataset.

you can learn how to do it from this link https://learn.microsoft.com/en-us/power-query/append-queries

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin