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 particular database source to Power BI Desktop, where will that imported data be store at?

Please help me out. Thanks!

 

-Vincent

Need Help

9 Replies

    • vlcc's avatar
      vlcc
      New Member
      10 years ago

      austinsense thanks for the reference. That will help once I get to exploring powerbi service more in depth. 

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi to all,

      I published on PowerBi Portal a data set from PowerBi Desktop, but in my Azure workspace I can't see the stored data (neither in Azure SQL Database, nor in Azure Blob). How can I see where data is stored ?

      Thanks!

  • ankitpatira's avatar
    ankitpatira
    Community Champion
    10 years ago

    vlcc

     

    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.

    • vlcc's avatar
      vlcc
      New Member
      10 years ago

      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

      • 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.