Forum Discussion
Need raw data behind Power BI obvience samples
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?
Hi atsats ,
You could refer to below link to enable refered add-in for your sample excel:
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
After hours of googling, this newbie is still having trouble. And I found
using DAX Studio that works great (easy and fast).
3 Replies
After hours of googling, this newbie is still having trouble. And I found
using DAX Studio that works great (easy and fast).
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
using DAX Studio that works great (easy and fast).
Hi atsats ,
You could refer to below link to enable refered add-in for your sample excel:
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