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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Power BI Header Change

Power BI Header Update

Read about the exciting updates for the Power BI forum.