Data Flow: Import files from folder but when the creation date matches a data in a custom calendar

[Anonymous]

I have done this in Power Query Desktop and it works fine but it gives me error in Data Flow.

I am importing multiple files from sharepoint folder location but before combining them I would like to filter filenames if the File Creation Date matches a calendar. I have created a calendar list and I use List.Contains function to check if the date in the Date Creation column matches in the list. Once those files are filtered then I'd like to combine the files and expand. It works fine in Power Query but Data Flow is giving me error in the "Binary" column.

Cannot convert the value "[Binary]" to type Binary

[collinq]

HI @Anonymous ,

I found this thread that seems to be similar - it has a few suggestions in it.  Let me know if this was helpful.

Solved: Expression.Error: We cannot convert the value "[Bi... - Microsoft Power BI Community

[Anonymous]

My problem occurs not at combing stage but adding a column with the following code

List.Contains(Calendar,[Date created])

It changes the Content column to [Error]

which says

Expression.Error: We cannot convert the value "[Binary]" to type Binary.

[collinq · Accepted solution]

Hey @Anonymous ,

This thread solved the issue through privacy level settings:

Solved: Re: Underlying error message: We cannot convert th... - Microsoft Power BI Community

And, i found a few threads that talked about it being a firewall issue - here is an older post about that : Expression.Error: Cannot convert the value "[Function]" to type Function (microsoft.com)

and this not as old one: Power Query Errors: Please Rebuild This Data CombinationThe Excelguru Blog

Let us know!

[Anonymous]

well the firewall argument can't be valid since i'm using sharepoint url as data source and Data Flow doesn't allow me to use gateway for it since they are publicly accessible urls.

but it was certainly privacy related. Privacy settings in Data Flow is tricky and Chris Webb's blog was useful.
Chris Webb's BI Blog: Power BI Data Privacy Levels And Cloud /Web-Based Data Sources Or Dataflows Ch...

Thank you for your help