Remove the limitation: "Power BI (web service) only supports importing or connecting to workbooks created in Excel 2007 and later. Workbooks must be saved as .xlsx or .xlsm file type." Thousands (...
David_Taylor2
6 years agoNew Member
I couldn't connect to an xlsb file with PBI Desktop due to this error. Seems strange that there are dozens of file type PBI can connect to but not an xlsb.
Recent ideas
Dynamic current-period defaults for separate Year and Month slicers
Scenario The target scenario is a report viewed in Power BI Service, using a DirectQuery semantic model and a dedicated Date dimension. Separate Year and Month slicers are part of the required user ...vvargasv12 hours agoMicrosoft EmployeeNew9Views0likes0CommentsAbout "Download SQL database project" and fix the downloaded project
1. The sqlproj must be fixed, it is downloaded without the xml markup line <?xml version="1.0" encoding="utf-8"> 2. The sdk must be updated: Actual: <Sdk Name="Microsoft.Build.Sql" Version="0.1...Jarrinf18 hours agoFrequent VisitorNew74Views3likes3CommentsAdd REST API to Take Ownership of Fabric Pipelines
When using service account to automatically deploy Fabric pipelines from Dev workspace to upper environments, the owner of pipelines in target envionment remain unchanged. In some situations, per...VickyPeng22 hours agoRegular VisitorNew364Views5likes2Comments