$filter and $select in Web.Contents() Query

[iDataDrew]

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."

[v-yalanwu-msft]

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: Underlying error message: We cannot convert the va... - Page 3 - Microsoft Power BI Communit...

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.