Lab 2 error

[Osama99]

Dear devleoprs,,

Any solution to lab2 files about this error

DataFormat.Error: 'PowerBI.accdb' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.
Details:
PowerBI.accdb

I'm using version 64 and office 365 and istalled AccessDatabaseEngine_X64.exe

[v-qiuyu-msft · Accepted solution]

Hi @Osama99,

Please open Query Editor via Edit Queries, click on the Source step in Applied Steps pane, make sure the actual file path is defined.

See:

Cannot edit queries from Lab 2

Best Regards,
QiuyunYu

[ayuicyi]

I am very new to PowerBI.  It is not clear to me what valid path should I select. I have selected the path that have the

"lab 2.pbix " file but what should I open the file as? . Can you please be a bit more specific?

The "Set up the Lab Environment " section of the PowerBI course has not mentioned any of these nor in any of the forum..and how am I suppose to know what to do as a new Power BI user? 

[Anonymous]

@v-qiuyu-msft I tried to update the source path but i still get the below mentioned error message. Do we need to download the data file somewhere else specific to lab2?

" An error occurred in the ‘International Sales’ query. Expression.Error: The column 'ProductID' of the table wasn't found.
Details:
ProductID"

Thanks,

Ganesan k.