Skip to main content

Dear Sir,

I am connecting through Cdata to Sharepoint Online.
I have hierarchies in my Sharepoint data, I can see them when I connect with PowerBI to my Sharepoint site. Can I use the Data Model feature ‘Flatten Documents’ like you can with JSon connectivity ?

It looks like CData for Sharepoint Online doesn't have this capability. Can I somehow bring these ‘hidden fields’ into my TimeXtender  project ?

In the attachment (Knipsel.PNG) you can see the hierarchical option in PowerBI with PowerQuery. I miss these fields when I connect with TX Cdata to the same Sharepoint site.

Hope you can shine a light on this.

Thank you in advance for looking into this case.
 

Regards,

Arthur
 

Hi @avanrijn 

What sort of settings do you use?

There are many fields that give back more info than others.

Hi Thomas,

Problem is solved.

I found the lookup tables in the Sharepoint Site.

Thanx.

 

Regards,

Arthur

Reply


Terms and ConditionsCookie settings