Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
I've started using Datamarts, and I've noticed an issue when connecting to Excel files stored in a SharePoint folder. Typically, PQ will detect and load the Excel workbook when I click into the [binary] for a file in the SharePoint folder.
In Datamart PQ, when I click the [binary] field, it does the Navigation step without importing the workbook and shows the Excel icon and information about the file. Typically when this happens in PQ, I can double-click the Excel icon and it will load the workbook or there is an option in Binary Tools to Open As and Excel document.
Neither of these options are available in Datamart PQ, but it is obviously capable of the same process since I can go into Advanced Editor and manually load the workbook using Excel.Workbook(Navigation). Is this intended behavior (including currently being developed for the tool) or is this a bug?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.