Bring Dataverse Table Column into PowerBI Desktop With API?

[Anonymous]

I need to bring a specific table from our one of our PowerApps Dataverse tables into PowerBI desktop. Initially, this is easily done by using the Dataverse connector and I'm able to pull the table into BI. However, one of the columns I need isn't showing and is instead packed up somewhere in several dozen structured columns. Rather than hunt thru literally hundreds of packed up columns, I was wondering if I might be able to use the column's API link instead. Viewing the column in PowerApps, I found an option that allows me to get the API link to the column data:

I get the string below when selecting 'API link to column data':

{"@odata.context":"https://soar.crm.dynamics.com/api/data/v9.2/$metadata#annotations(annotationid)","value":[{"@odata.etag":"W/\"3578699\"","annotationid":"707c93f6-0836-ed11-9db1-000d3a371198"},{"@odata.etag":"W/\"3578695\"","annotationid":"53958af3-0836-ed11-9db1-000d3a37125b"},{"@odata.etag":"W/\"3578697\"","annotationid":"54958af3-0836-ed11-9db1-000d3a37125b"},{"@odata.etag":"W/\"16132006\"","annotationid":"cc581b8f-567a-ed11-81ad-002248049e4d"},{"@odata.etag":"W/\"16196425\"","annotationid":"af587549-747d-ed11-81ad-002248049e4d"},{"@odata.etag":"W/\"16196431\"","annotationid":"13b6dd4f-747d-ed11-81ad-002248049e4d"},{"@odata.etag":"W/\"16196476\"","annotationid":"1db6dd4f-747d-ed11-81ad-002248049e4d"},{"@odata.etag":"W/\"16196470\"","annotationid":"29b6dd4f-747d-ed11-81ad-002248049e4d"},{"@odata.etag":"W/\"16196464\"","annotationid":"2db6dd4f-747d-ed11-81ad-002248049e4d"},{"@odata.etag":"W/\"16196565\"","annotationid":"6afc168b-757d-ed11-81ad-002248049e4d"}]}

How, or can, I use this string in BI Desktop to bring that column data in?

[Anonymous]

from my limited experience i've seen API links through OData feeds (from "https://" onwards, copy/paste that into the feed and see if it loads).

[Anonymous]

No joy using the Odata connector. Using just the URL :

https://soar.crm.dynamics.com/api/data/v9.2/

Initially brings up a list of columns/tables and I can preview them in the preview window. However, when I try to load them into the report, I get the following error message after a minute or two:

There must be a better way of doing this. Probably related to my unfamiliarity with PowerApps, but it seems like there should be better interoperability betwee PowerBI and PowerApps. 

[Anonymous]

When I've experienced that error it's a result of time out using the OData connector.

If you're using a dataverse connector try using the Legacy try using the Legacy Common Data Service connector.

This method should bring your Lookup columns through with their GUID's to enable Joins between tables, and Choice columns will come through with both the ID and a Name column (giving the description).

[Anonymous]

Using the Legacy Common Data Service connector initially looked promising. The preview window showed the column I'm looking for (though it's in base64, headache for another time).

However, when loading the table into Desktop, after about 10 minutes I get the following error:

I'm beginning to think there's something messed up on the server side but I've no idea what it would be.