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
6 years agoImpactful Individual
Hello 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
Add "Add to Dictionary" and "Ignore All" Functionality to Power BI Text Boxes
When creating professional Power BI reports, legitimate company names, project names, industry-specific terms and technical terminology are sometimes incorrectly flagged as spelling errors with a red...mmartelozzo7 hours agoNew MemberNew4Views0likes0CommentsFix Direct Lake semantic model binding in Deployment Pipelines
When deploying Direct Lake semantic models via Deployment Pipelines, the Lakehouse source is incorrectly treated as an external SQL source. This results in broken lineage and prompts for credentials....lk12317 hours agoAdvocate INew1.5KViews27likes2Comments