Forum Discussion

Amarinho777's avatar
Amarinho777
New Member
3 years ago
Solved

Automatically transform and append data

Hello,   In my company we have multiple projects which produce one excel per quarter which contains financial data. The Excels are stored on a Microsoft Azure powered Data Lake.   I have created ...
Need Help
Tips and Tricks
  • v-xiaosun-msft's avatar
    v-xiaosun-msft
    3 years ago

    Hi Amarinho777 ,

     

    If we have multiple files that have the same schema, we can combine them into a single logical table by using Power Query. 

    Select Content and select Home > Combine Files. Or you can just select the Combine Files icon next to Content.

     

    Please reference the following document.

    Combine files (binaries) in Power BI Desktop - Power BI | Microsoft Learn

     

    Best Regards,
    Community Support Team _ xiaosun

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

v-xiaosun-msft's avatar
v-xiaosun-msft
Icon for Community Support rankCommunity Support
3 years ago

Hi Amarinho777 ,

 

If we have multiple files that have the same schema, we can combine them into a single logical table by using Power Query. 

Select Content and select Home > Combine Files. Or you can just select the Combine Files icon next to Content.

 

Please reference the following document.

Combine files (binaries) in Power BI Desktop - Power BI | Microsoft Learn

 

Best Regards,
Community Support Team _ xiaosun

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