cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Data Source Error, Cannot open query editor

Hi All,

 

I have been trying to open the query editor but unsucessful and I have the excel worksheet attached to the PowerBI workbook but do not have the excel file locally. There is a need to try out powerquery and unfortunately PowerBI doesn't allow me to open the query editor. Is there an alternate solution to open the editor without the local file.

 

I have tried several methods and none of it works.

 

Thank you in advance.

1 ACCEPTED SOLUTION

HI @Anonymous ,

Actually, in your scneario, if you don't have the original data source, you will have no access to use the PowerQuery.

Best Regards,

Teige

View solution in original post

4 REPLIES 4
Anonymous
Not applicable

The powerbi workbook was sent from someone else, I can view the data but not edit queries. I do not have the file locally. 

 

Apologise, if the question sounds silly, I am a begineer.


@Anonymous wrote:

Hi All,

 

I have been trying to open the query editor but unsucessful and I have the excel worksheet attached to the PowerBI workbook but do not have the excel file locally. There is a need to try out powerquery and unfortunately PowerBI doesn't allow me to open the query editor. Is there an alternate solution to open the editor without the local file.

 

I have tried several methods and none of it works.

 

Thank you in advance.


 

HI @Anonymous ,

Actually, in your scneario, if you don't have the original data source, you will have no access to use the PowerQuery.

Best Regards,

Teige

TeigeGao
Solution Sage
Solution Sage

Hi @Anonymous ,

>>I have the excel worksheet attached to the PowerBI workbook but do not have the excel file locally

Could you please tell us how did you attach the Excel Worksheet to the PowerBI workbook? If what you mentioned is importing the data to PowerBI, when you open the PowerQuery, it will find the data source, if the data source cannot be found, it will return an error message.

Best Regards,

Teige

RobbeVL
Impactful Individual
Impactful Individual

I dont think that will be the problem.

What error do you get? Normally you're always able to open PowerQuery even when you dont have that file. You just wont be able to refresh it. 

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.