Unable to schedule refresh due to hand made query

[hejszyszky]

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!

[AllisonKennedy]

Not sure what your data source is, but here's my experience on this error: https://excelwithallison.blogspot.com/2021/07/tokyo-olympics-schedule-refresh-in.html 

[hejszyszky]

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]

@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.