Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I'm working from home because of the coronavirus. I want to merge two tables using Query Editor. But when I go to Query Editor I get the error message "An error occurred in the ‘Sample File’ query. DataSource.NotFound: File or Folder: We couldn't find the folder 'S:\....Excel Files\*'". I don't have VPN so my Power BI file on my home laptop doesn't have a network connection to the original data files at work; however the original data files are all loaded into my Power BI file - my Power BI file has all the data within it from the original data files. Can I operate Power BI without a network connection to the original data files? If yes, how do I do that?
Solved! Go to Solution.
Not in Power Query. It requires access to the data. The DAX/Visualizaition side can as it works "locally" with what Power Query loaded in the model.
Note that PQ data can be in the cloud, so Excel or CSV files in SharePoint online will work from anywhere, but that is a network connection to those places vs a local drive.
Unfortunately, you either need to get the source files, put the files in a supported cloud location, or remotely control your PC at work. If you can get the files on your local PC, you can easily change their locations in Power Query using the Data Source icon to change the file path, then change back when you get back to work.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingHi , @pmcinnis
I’m afraid not unless your have the copy of your datasource in your home laptop.
If you have the copy of data source on your home laptop , you can change your datasource setting.
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi , @pmcinnis
I’m afraid not unless your have the copy of your datasource in your home laptop.
If you have the copy of data source on your home laptop , you can change your datasource setting.
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Not in Power Query. It requires access to the data. The DAX/Visualizaition side can as it works "locally" with what Power Query loaded in the model.
Note that PQ data can be in the cloud, so Excel or CSV files in SharePoint online will work from anywhere, but that is a network connection to those places vs a local drive.
Unfortunately, you either need to get the source files, put the files in a supported cloud location, or remotely control your PC at work. If you can get the files on your local PC, you can easily change their locations in Power Query using the Data Source icon to change the file path, then change back when you get back to work.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingThanks for the solution!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |