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
ankitpatira's avatar
ankitpatira
Community Champion
10 years ago

vlcc Once dataset is published to powerbi service  you can use powerbi service to create new reports as well using that published dataset (but with limited functionality). However from powerbi desktop you can't connect to published dataset nor you can download published dataset. 

 

You can't open pbix file in Excel however there is a feature called Analyze in Excel which lets you connect live to published dataset from microsoft excel. 

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.