cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Regular Visitor

No .pbix option in "Open file as" dialog

I am working  through examples from Pro Power BI Desktop by Adam Aspin. In Chapter 7, page 184, it says to launch Power BI Desktop and open C:\PowerBIDesktopSamples\Example1.pbix. This is successful. Next, it says to click on Transform Data. I do, and the Query Editor opens as expected. However, I get the following error:

DataSource.Error: Could not find file 'C:\PowerBiDesktopSamples\BrilliantBritishCars.xlsx'.

Details:     C:\PowerBiDesktopSamples\BrilliantBritishCars.xlsx

I click on the “Go to Error” box, then on “Edit Settings”. It turns out the path is

C:\PowerBiDesktopSamples\BrilliantBritishCars.xlsx.

So, I change this to C:\PowerBiDesktopSamples\Example1.pbix.

The problem is, in the Open file as dialog, there is no .pbix option so the error will not go away.

How can I fix this?

8 REPLIES 8
Community Support
Community Support

Hi @jgscott3 ,

 

Did you unzip the .zip file and make sure the "BrilliantBritishCars.xlsx" 's location is "C:\PowerBiDesktopSamples\BrilliantBritishCars.xlsx"?

 

 

Best regards

Icey

 

If this post helps, then consider Accepting it as the solution to help other members find it faster.

Super User III
Super User III

Hello @jgscott3 

 

on these examples to show you how Power Query is working, they used an Excel-file. You need to check out if this file can be downloaded as well, otherwise you are not able to go through the lection.

 

BR

 

Jimmy

Thanks. I downloaded everything in the .zip file provided. Also, the author specifically says to open the .pbix file. No matter; I wound up copying the data to Excel and then using the Get Data function to load it as an Excel file. So, we came to the same conclusion:)

Super User III
Super User III

Hi @jgscott3 

I'm confused.  You said the error is caused by the path to a file not being correct but you've changed the filename?

If your query can't find C:\PowerBiDesktopSamples\BrilliantBritishCars.xlsx then change the query to poin to that file wherever it is.

It sounds like you've modified the query to load C:\PowerBiDesktopSamples\Example1.pbix but if the query is looking for an Excel file, this change will not fix the issue.

Locate the BrilliantBritishcars.xlsx file and change the query to point to it.

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


As I said, I changed the path to C:\PowerBiDesktopSamples\Example1.pbix. This is the desired path and file. The problem is Power BI is still looking for an .xlsx file in the path and doesn't find one. When I try to change the file type in the Open file as dialog, there is no .pbix option so the error will not go away.

Hi @jgscott3 

Please post the query that is causing the error.

Thanks

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


It never gets far enough to become a query.

Hi @jgscott3 

Just saw your post on the Desktop forum.  From the screenshot it looks like you have opened the Example1.pbix file in PBI and are then trying to use the same file as a data source. It doesn't work that way, you can't use a file as a datasource for itself.

You said you  changed the path to C:\PowerBiDesktopSamples\Example1.pbix. This is the desired path and file - how do you know this is correct?  The initial error said it couldn't find the BrilliantBritishCars.xlsx file.  I still think you need to locate that file and point your PBIX file at it so it canload the workbook data.

Phil


If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors