files combine and load using folder in power BI

[SukanyaGG]

My data is not geeting combine if I do combine using folder when Im uploading the data to power Bi. 

Both has same column no of data and with same column name. 

It is two different moth data which im trying to combine.

What I need to consider while uploading data from folder and why im getting like this. 

I need to data to be refreshable every month.

Can you sugest any other methond I can follow. 

attached screenshoot for ref

[Uzi2019 · Accepted solution]

Hi @SukanyaGG 

You can  try this way by using Power query. Refer below videos for better understsnding

https://www.youtube.com/watch?v=x30ssa2K9gU

https://www.youtube.com/watch?v=g7jzDM39YnM

https://www.youtube.com/watch?v=Nbhd0B5ldJE

I hope I answered your question!

[v-kaiyue-msft · Accepted solution]

Hi @SukanyaGG ,

Your solution is great, @Uzi2019 . Here I have another idea that I want to share for reference.

Select the folder data source in Power BI Desktop, enter the folder path, select OK, and then select "Convert Data" to view the folder's files in the Power Query editor.

In the Power Query Editor, select Content (the first column label) and click the double-arrow icon next to the column name.

Select the tables to merge and click OK.

For more details, please refer to the link: Combine files (binaries) in Power BI Desktop - Power BI | Microsoft Learn.

For refresh issues, you can consider configuring planned refresh in power bi service. In the "Planned Refresh" section, you can define the frequency and time slot for refreshing the semantic model. Some data sources do not require a configurable gateway to refresh, while other data sources require a gateway.

For more details, please refer to the documentation: Configure scheduled refresh - Power BI | Microsoft Learn

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Uzi2019 · Accepted solution]

Hi @SukanyaGG 

You can  try this way by using Power query. Refer below videos for better understsnding

https://www.youtube.com/watch?v=x30ssa2K9gU

https://www.youtube.com/watch?v=g7jzDM39YnM

https://www.youtube.com/watch?v=Nbhd0B5ldJE

I hope I answered your question!