Using Power Query to connect to Speckle inside Excel

[BaudouinNP (de Montarnal)]

Update:

it doesn’t quite work because the Excel access to the powerBI datasets is linked to the dataset published online on your SharePoint-PowerBI profile… and… the online power bi report or dataset isn’t automatically updated when a new commit comes in the stream (contrary to PowerBI Desktop), because Speckle is a custom connector (see feed below).

Actualization of powerBI online dashboards fails

Hi everybody, In my exploration of Specke and PowerBI, I have another feedback to give you After the publication of a Power BI Desktop Dashboard online to Power BI (Web), it is theoretically of course possible to update your online dashboard with the changes you have been doing on the Desktop App. In our case, we face an error because of the data source → Speckle [image] Did you meet this problem before ? Here are some forum contents that might be helpful: …

So I guess we are back to square one would be nice to implement all the power query functions developed for PowerBI into the Excel Connector, to be able to read the speckle data stream and play with it directly in excel. (to have a dynamic excel table that updates itself automatically when new commits come).