Forum Discussion
Power BI Data Store location
ankitpatira I can conclude that there is no local datastore or temp folder to store that imported dataset in powerbi desktop. Do I get it right? This will lead to second question, once the dataset is published to powerbi site can we retrieve that published dataset to be opened in powerbi desktop? Will we be able to open that dataset (.pbix) in other application lets say in Excel? thank you
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.
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.
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.
