Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
I currently have a file storage in sharepoint with a sharepoint folder column to indicate if I wish the file to be included in the Dataflow combined step. This would allow files to be dynamically added/removed from the dataflow without having to manually edit the flow.
However I cannot bring the file contents (Binary) into a connector with the metadata (sharepoint column) so currently need to use Sharepoint.Contents connector for the binary files and Sharepoint.Tables for the Sharepoint column and then merge the queries together on the file name.
Does anyone know a way of bringing the Binary or the metadata together in just one query?
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!