Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
SukanyaGG
Regular Visitor

files combine and load using folder in power BI

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 refCapture.PNG

2 ACCEPTED SOLUTIONS
Uzi2019
Super User
Super User

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!

 

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

View solution in original post

v-kaiyue-msft
Community Support
Community Support

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.

vkaiyuemsft_0-1714455681748.png

 

Select the tables to merge and click OK.

vkaiyuemsft_1-1714455691165.png

 



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.

vkaiyuemsft_2-1714455771368.png

 

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.

View solution in original post

2 REPLIES 2
v-kaiyue-msft
Community Support
Community Support

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.

vkaiyuemsft_0-1714455681748.png

 

Select the tables to merge and click OK.

vkaiyuemsft_1-1714455691165.png

 



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.

vkaiyuemsft_2-1714455771368.png

 

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
Super User
Super User

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!

 

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.