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
Native KPI Governance, Ownership and Business Change Impact in Microsoft Fabric
Native KPI Governance, Ownership and Business Change Impact in Microsoft Fabric Idea In enterprise analytics, one of the biggest challenges is not creating a KPI, but ensuring that everyone agrees ...kulkarnigauri33 hours agoNew MemberNew3Views0likes0CommentsEnable writing PowerQuery type time (from Dataflow Gen2) to Warehouse type time
Currently the UI throws an error while I am trying to write Data typed as "time" in Power Query to a Fabric Warehouse. I would prefer to import data typed as "time" in Dataflow Gen2 PowerQue...pyd4life5 hours agoAdvocate INew105Views2likes1CommentAllow sharing of Office 365 Email (Outlook) cloud connections in Manage connections and gateways
The Problem When creating an Office 365 Email (Microsoft Outlook) cloud connection in Manage connections and gateways, it is impossible to share the connection with other users or security groups. A...akim-microsoft6 hours agoMicrosoft EmployeeNew233Views4likes1CommentShow the workspace name for duplicate SQL endpoints with the same name in Desktop PowerBI
When multiple Fabric SQL endpoints have the same name, Power BI Desktop should display the source workspace name alongside the endpoint name during connection and in imported table metadata, so users...WorkFull227 hours agoAdvocate INew1View0likes0Comments