Forum Discussion

hejszyszky's avatar
hejszyszky
Icon for Helper II rankHelper II
4 years ago

Unable to schedule refresh due to hand made query

Hi,

I've created query to take all files from 4 different folders to concatenate with code below.

 

 

Which I believe caused error below : 

 

 

 

 

When trying to refresh or schedule refresh in power bi service i get the error below:

 

 

 

Did someone handle situation/problem as above? I've only seen solutions to problem above when getting data from some web sources ...  Any ideas if there is a way to do it for .xls files/handmade queries? Also, the files are stored on network drive.

Thanks in advance!

Need Help
Tips and Tricks
Tutorial Requests

3 Replies

    • hejszyszky's avatar
      hejszyszky
      Icon for Helper II rankHelper II
      4 years ago

      Hi AllisonKennedy ,
      Thanks for your reply. My data source is around 30-40 .xlsx files with same data structure from 4 different folders on network disk so sth like :M/PRO/A , :M/PRO/B, etc. These files are joined/concatenated with power query's get data from folder - modified due to four diffrent locations.
      So regarding your solution i am not able to create web links...

      Do you think is there a way to make this data source static?

      • AllisonKennedy's avatar
        AllisonKennedy
        Icon for Community Champion rankCommunity Champion
        4 years ago

        hejszyszky Hmm, I don't use local network drives - all my data is in SharePoint so can use the URL trick. 

        You might be able to get it working if you can provide a filepath that is a valid data source at each step of the query/source.

        Otherwise if it's only 4 folders, you could create 4 queries for each using 'from folder' and append them?

         

        ImkeF  is the Power Query guru so will see if she has any ideas on this as well.