Need Help On Binary Combination Automation

[Anonymous]

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!!

[Icey]

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]

@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