Forum Discussion
Data Flow: Import files from folder but when the creation date matches a data in a custom calendar
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
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!
4 Replies
- collinq
Super User
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
- collinq
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!