Invoke Custom Function Error, Data flow reading data from sharepoint folder

[amirghaderi]

I have started migrating my data sources from Power Bi desktop to data flow. I have a set of data which are stored in sharepoint folder (Excel files, dated for each week). they get imported to desktop model as expected and has been working for a long time.

Any idea for the reason? I have shown the query in both desktop and data flow 

I copied the query to Data flow query and it fals when it starts ready the custom Invoke function to read the contents.

Screenshot from Data Flow:

Screenshot from desktop PBIX

[GilbertQ]

Hi @amirghaderi 

As far as I understand if you are calling another function you might need Power BI Premium Per User or Premium in order for that to run before invoking this query?

[amirghaderi]

I  think I am getting to the reason.

The files have been saved as CSV format in the folder. I saved them as Excel and the function worked as desktop version.

Is there any way to import them as CSV or I should save all files as Excel. It will not be ideal, if this is the only soloution

[amirghaderi]

I am Pro user and company has Premium liecences for all users.

[GilbertQ]

Hi @amirghaderi 

I would suggest looking to use a Premium App Workspace and then see if the function then works?

[amirghaderi]

I am working in Premium workspace