Forum Discussion
Anonymous
7 years agoNot 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 ...
- 7 years ago
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
7 years agoSolution 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