Need raw data behind Power BI obvience samples

[atsats]

I'm trying to get the raw data behind some of the Power BI samples on this page:

https://docs.microsoft.com/en-us/power-bi/sample-datasets

But, when I try to get the Excel workbook for any sample, such as from here (https://docs.microsoft.com/en-us/power-bi/sample-retail-analysis) with this download link: http://go.microsoft.com/fwlink/?LinkId=529778

I get this Excel spreadsheet:

and the raw data is not available. I tried refreshing the data connections manually, but that generates another error about a database not being available (see below image). 

Are these sample databases available? If not, how do we get the raw data behind these Power BI Samples?

[v-danhe-msft · Accepted solution]

Hi @atsats ,

You could refer to below link to enable refered add-in for your sample excel:

https://docs.microsoft.com/en-us/power-bi/sample-datasets#optional-take-a-look-at-the-excel-samples-...

And you could use import function to load the excel with data model:

https://docs.microsoft.com/en-us/power-bi/desktop-import-excel-workbooks

Regards,

Daniel He

[dvb · Accepted solution]

After hours of googling, this newbie is still having trouble. And I found

https://www.biinsight.com/quick-tips-export-power-bi-desktop-and-power-bi-service-model-data-as-a-wh...

using DAX Studio that works great (easy and fast).

[atsats]

Wow, pretty impressive that you figured this out. I had given up after posting the question a few weeks ago. 

Your find is very useful; thanks for posting!

---

@dvb wrote:

After hours of googling, this newbie is still having trouble. And I found

https://www.biinsight.com/quick-tips-export-power-bi-desktop-and-power-bi-service-model-data-as-a-wh...

using DAX Studio that works great (easy and fast).

---

[v-danhe-msft · Accepted solution]

Hi @atsats ,

You could refer to below link to enable refered add-in for your sample excel:

https://docs.microsoft.com/en-us/power-bi/sample-datasets#optional-take-a-look-at-the-excel-samples-...

And you could use import function to load the excel with data model:

https://docs.microsoft.com/en-us/power-bi/desktop-import-excel-workbooks

Regards,

Daniel He