Forum Discussion
Data Flow: Import files from folder but when the creation date matches a data in a custom calendar
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!
Super UserHI 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
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
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!
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 Chris Webb's BI Blog (crossjoin.co.uk)Thank you for your help