Forum Discussion
$filter and $select in Web.Contents() Query
I'm trying to write a dynamic query that looks at a date parameter (DateParam). The following works but the Service does not allow scheduled refresh because it's a dynamic query:
Working Query
I'm trying to turn this into a Web.Contents query using the RelativePath so that scheduled refresh will work. The below is what I did:
However, I keep getting the following error: "Expression.Error: We cannot convert a value of type Binary to type Table."
1 Reply
- v-yalanwu-msftCommunity Support
Hi, iDataDrew ;
I found an old thread showing a solution,you may have a try:
Solved: Web-api stops my dataset from refresing - Microsoft Power BI Community
Solved: Expression.Error: We cannot convert a value of typ... - Microsoft Power BI Community
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.