Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Osama99
New Member

Lab 2 error

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

1 ACCEPTED SOLUTION
v-qiuyu-msft
Community Support
Community Support

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.

 

q5.png

 

See:

Cannot edit queries from Lab 2

 

Best Regards,
QiuyunYu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
v-qiuyu-msft
Community Support
Community Support

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.

 

q5.png

 

See:

Cannot edit queries from Lab 2

 

Best Regards,
QiuyunYu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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
Not applicable

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

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!