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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Need Help On Binary Combination Automation

Hey Guys,

 

I was curious on if there is a capability for Power BI or if anyone knows how I can accomplish this. For our company we want to use a Flow (which I did understand how to do) to get weekly reports sent to my email to be sent to a sharepoint folder. I have 15 different reports, all of which go into a seperate folder (15 folders in total) on sharepoint.

My hope is I can schedule a refresh of the data and it can pull the updated new excel files inside the sharepoint that came from that weekly email, and be able to have the system automatically combine all of the binary files so the 1 "master file" is always kept up with.

 

I hope this made sense as it's hard to explain, but please ask any clarity if it seems unclear. Thanks all!!

2 REPLIES 2
Icey
Community Support
Community Support

Hi @Anonymous ,

 

Please check if these documents could help you:

Combine files (binaries) in Power BI Desktop;

Combining Excel Files hosted on a SharePoint folder with Power BI.

 

 

Best regards

Icey

 

If this post helps, then consider Accepting it as the solution to help other members find it faster.

amitchandak
Super User
Super User

@Anonymous , Not clear on you need power bi share point or share point to power bi

 

Refer these connectors

https://flow.microsoft.com/en-us/search/?q=power+bi+to+sharepoint

 

from power Bi to file

https://www.thebiccountant.com/2019/04/01/export-data-from-power-bi-using-microsoft-flow/

 

sharepoint to power bi

https://sharegate.com/blog/using-power-bi-for-additional-sharepoint-reporting

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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