Access reports as JSON from the /beta endpoint results in a parsing issue in Power BI

[SteveBurkettNZ]

Opening this Issue for discussion around the problem whereby some attempts for OData feed queries to /beta/reports in Power BI Desktop results in an error:

Details: "We were unable to resolve the type name 'Collection()' to an EdmType"

I'm getting some success by using the Web type query rather then OData feed type, it allows you to drill down through various List and Record entries to get to the final data you're after. Not sure yet how to make use of that yet though!

[YannickRe]

Hi @SteveBurkettNZ ,

Thank you for looking into this! I was never able to figure it out, but it also didn't block my use cases so I just jotted it down to a known issue. Using Web could be a workaround, depending on the datasource. Web doesn't understand ODATA itself but can parse the data, so everything that is returned within one query can be used. Problems start when there is paging involved etc. as the Web connector didn't/doesn't follow @odata.next etc.