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

Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote now!

Reply
Wis
New Member

Why I cant use or insert any database ?

  

30859A16-0D2E-4418-A44E-932A39480E30.jpeg

F22C00D4-5A99-4E47-967C-1D43E67D1E49.jpeg

1 ACCEPTED SOLUTION

It's still the same issue. Yes it is an excel workbook

View solution in original post

2 REPLIES 2
danextian
Super User
Super User

hi @Wis 

 

Based on the screenshot, you are only accessing the file as binary but you did not specify what file type you are accessing. For Excel files from a local drive, the formula to access it would be: Excel.Workbook(File.Contents(path))
For Excel files from the web Excel.Workbook(Web.Contents(path))





Dane Belarmino | Microsoft MVP | Proud to be a Super User!

Did I answer your question? Mark my post as a solution!


"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

It's still the same issue. Yes it is an excel workbook

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

Vote for your favorite vizzies from the Power BI World Championship submissions!

Sticker Challenge 2026 Carousel

Join our Community Sticker Challenge 2026

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

January Power BI Update Carousel

Power BI Monthly Update - January 2026

Check out the January 2026 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.