Forum Discussion
Power BI Data Store location
On top of what austinsense said, in powerbi desktop until you publish to powerbi service, data is stored locally within powerbi in pbix (powerbi file) file.
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.
