How to download the .aacd contoso dataset

[Anonymous]

Hey, guys.

I've downloaded the contoso file available at the Microsoft official website, and as I tried to perform some transformation in its data in Power Query, the following error message showed up:

DataFormat.Error: 'ContosoSalesV31_64bit.accdb' is not a valid path. Check...

Details:
ContosoSalesV31_64bit.accdb

Here's my question: does anyone know where (preferable a link) I can download this .accdb file so I can change some things in Power Query?

Thanks in advance.

[OwenAuger]

Hi @Anonymous 

I had a look around and couldn't find the exact Access Database file online, but I found a slightly different version of the Access database files along with Excel files here.

I adjusted the PBIX to connect to these files & the model appears to be essentially identical after loading the data.

I've packaged them together here.

ContosoSalesFixed.zip

Just change the Power Query "Source Folder" parameter to the folder where the source files are saved:

Regards

[PhilipTreacy · Accepted solution]

Hi @Anonymous 

Are you using the Access Database Connector in PBI Desktop?

Read this -> Power Query Access database connector - Power Query | Microsoft Learn

If you are using this connector and pointing it to the file, not sure why you'd be getting that error.

regards

Phil

[Anonymous]

Thanks a lot, man.