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

YannickRe / ms-graph-proxy-function

Azure Function that acts as a Proxy to the Microsoft Graph, for the purpose of allowing Power BI to connect to the Microsoft Graph

20 stars 10 forks source link

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

Open SteveBurkettNZ opened 4 years ago

SteveBurkettNZ commented 4 years ago

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 commented 4 years ago

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.