Matt Allington on 10 Nov 2016 08:25:30
It is possible to open Power BI Desktop, detect the port number, open Excel, connect to the running local instance of Power BI Desktop as a local SSAS instance and then build a pivot table over the local server. You can do this using DAX Studio.
This is very useful and as more people build Power BI Desktop files as the main data model, this will become more important. There is an "Analyze in Excel" feature in the Power BI Service and I would like to see the same for Power BI Desktop.
As a suggested approach to a solution, you could enhance the Power BI Ribbon in Excel. There is already a "Connect to Data" button that connects to the service. You could enhance this to include a button that connects to a local instance of Power BI Desktop running on the PC.
Administrator on 17 Jun 2021 00:22:35
With the External Tools integration, users can now connect various tools to a local Power BI desktop instance including Excel.
- Comments (21)
RE: Use Power BI Desktop as a Local Server on a PC
Its possible. you have to identify the TCP port used by the local instance of PowerBI and connect to it through Excel.
I saw a blog post about this, I juist test the SSMS connection, so Excel will be able to do it too