Selecting more than one excel in in folder in PowerQuery for Excel Causes and Error after Combining the Binaries Get & Transform From File From Folder Select more than one file let Source = Fol...
chass
Impactful Individual
6 years agoHello David, I am able to get your M query to run on my computer...See below. Perhaps you have one of the files open? Thanks Chuck let Source = Folder.Files("C:\uv"), #"Combined Binaries" = Binary.Combine(Source[Content]), #"Imported Excel" = Excel.Workbook(#"Combined Binaries") in Source
Recent ideas
Allow Managed Private Endpoint to be disabled/enabled per notebook
Could notebooks have an option to use or not use the workspace's Managed Private Endpoint (MPE)? MPE can significantly increase notebook startup time, even for notebooks that don't need private conn...frithjof_v13 hours agoCommunity ChampionNew21Views1like0CommentsMatrix: column totals as a bar chart docked to the edge
What's missing Data bars already work on the Total row and column through conditional formatting, so row totals can be read as length. Column totals cannot: they render as a horizontal bar inside a ...Sayurivalente1 day agoRegular VisitorNew80Views6likes1Comment