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?
As this is a new feature currently in Preview, we have received feedback from the PG team that binary content is not supported at this time. We will log it as a bug and fix it later on, but for now please CX to load and extend the SPO file in one query.