How do i get the Contenttype of Shaepoint List

[Quicksilver]

Hi

I have Data from a Sharepoint Onlie List which contains different Contenttypes (one for Project's and one for Services). 

In Power BI i get a column with  a ContentTypeId (which i asume, this is the Contenttype from the Sharepointlist), but i don't see any Cleartext of the Content Type and also no Table with the Contenttypes.

How and where can i get the Contenttype from (in Cleartext e.g. for filtering, ordering ...) ?

Thanks for Replies

[Greg_Deckler]

https://docs.microsoft.com/en-us/previous-versions/office/developer/sharepoint-2010/aa543822(v=offic...

https://docs.microsoft.com/en-us/previous-versions/office/developer/sharepoint-2010/ms452896(v=offic...

[Quicksilver]

Yes, i see and know where and how its managed in Shareppoint itself. But my question is, where can i get it in Powerbi to make a Join to this List , e.g. i want to filter a Visual (PowerBi) by the Contenttype ( and offcourse not by the cryptic Value in the Contenttable 🙂 so i need the Table (List) of the contenttypes in PowerBI (without codeing).

thx

[OneWithQuestion]

Did you ever solve this issue?