Forum Discussion
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
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
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.
