Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
harshipsns
Frequent Visitor

Transpose is not working for a table where OData is the source in PBI desktop

HI Team,

 

I am trying to transpose my table, as I need a table view of all the fields which are the columns at present. SO I am trying to transpose the table so that I can get the fields as rows and I can use a table visualization for that table.  But when I am trying to transpose the table it is throwing me an error saying that Incompatrable types are found. We have nested columns in the Odata source, but I expanded them and cleaned the table before trying to transpose but still not working.

 

 We couldnt parse OData result. Error: Incompatable type kinds are found. The type was found to be complex instead of primitive

1 REPLY 1
harshipsns
Frequent Visitor

pic1.png

 

pic2.png

 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.