Forum Discussion

vlcc's avatar
vlcc
New Member
10 years ago

Power BI Data Store location

Hello everyone,   I am new to Power BI. I have learned couple of things that Power BI is capable of doing. I found one thing that I could not figure out the answer. By the time we get data from a p...
Need Help
Bahhoussi's avatar
Bahhoussi
New Member
10 years ago

ankitpatira Is it possible to use this feature "analyze in excel" directly from Power BI desktop ? Otherwise is it possible to send a Power BI dataset to excel without going through power BI service ? 

Thanks a lot.

austinsense's avatar
austinsense
Impactful Individual
10 years ago

The answer is yes - here's how it works.

 

1. Open Your Power BI model.

2. You have to figure out which port Power BI is running on. Download this tool and find the "Remote Port" for Power BI Desktop

3. Go to excel and create a connection to "Analysis Services" - the server name is "localhost:[Remote Port]"

 

That's it.  When you close and re-open Power BI Desktop it will be assigned a new port number so you'll have to change that in Excel. It would be SO easy for Microsoft to build this feature into the product - You can vote on it here.