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
FET_369
New Member

POWER BI '267' error

I am using power BI for revit model health report and i have created and extracted model health data from revit. When I open the template file for power BI it prompts me to add an excel file. When I do so I get the '267' error. The file path isnt going through one drive and I pasted the path without "" on the ends of it. I can figure out why it cant read the excel fileScreenshot 2024-11-14 184906.pngScreenshot 2024-11-14 185345.png

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

Hi, @FET_369 

 

This error typically indicates that the directory name is invalid. 

 

You can try the following methods to troubleshoot the problem:

  • Check the File Path: Ensure that the file path you are using is correct and accessible. 
  • Verify Permissions: Ensure that you have the necessary permissions to access the Excel file.
  • Use Full Path: Make sure you are using the full path to the Excel file. For example, instead of using a relative path, use the complete path like C:\Users\YourName\Documents\YourFile.xlsx.
  • Update Power BI: Ensure that you are using the latest version of Power BI.

 

Best Regards,

Community Support Team _Charlotte

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-zhangtin-msft
Community Support
Community Support

Hi, @FET_369 

 

This error typically indicates that the directory name is invalid. 

 

You can try the following methods to troubleshoot the problem:

  • Check the File Path: Ensure that the file path you are using is correct and accessible. 
  • Verify Permissions: Ensure that you have the necessary permissions to access the Excel file.
  • Use Full Path: Make sure you are using the full path to the Excel file. For example, instead of using a relative path, use the complete path like C:\Users\YourName\Documents\YourFile.xlsx.
  • Update Power BI: Ensure that you are using the latest version of Power BI.

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Bibiano_Geraldo
Super User
Super User

Hi @FET_369,

Make sure that power bi have permission to access that file.

Try to Load the File in Power Query

  • Open Power BI Desktop.
  • Click Get Data > Excel and manually select the file.
  • If it works, reassign the file path in your query.

I hope this helps! 🎯

If you found this answer helpful:

✔️ Mark it as the solution to help others find it faster.

👍 Give it a kudo to show your appreciation!

Is this post help you? Please consider to:
Accept as Solution!
Give a Kudo
Follow me on Linkedin: Bibiano_Geraldo_Mangue
amitchandak
Super User
Super User

@FET_369 , Usually error when it not able to read file. Check if file open and locked. Or got renamed or moved.

Open power query and refresh and check query step by query step for an error

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

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!