Skip to main content
To homepage To homepage
Solved

Cdata Sharepoint connection Data Model feature

  • October 14, 2024
  • 2 replies
  • 35 views
avanrijn
Contributor
Forum|alt.badge.img+2

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
 

Best answer by avanrijn

Hi Thomas,

Problem is solved.

I found the lookup tables in the Sharepoint Site.

Thanx.

 

Regards,

Arthur

View original
Did this topic help you find an answer to your question?

Thomas Lind
Community Manager
Forum|alt.badge.img+5
  • Thomas Lind
  • Community Manager
  • October 14, 2024

Hi @avanrijn 

What sort of settings do you use?

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

avanrijn
Contributor
Forum|alt.badge.img+2
  • avanrijn
  • Contributor
  • October 15, 2024

Hi Thomas,

Problem is solved.

I found the lookup tables in the Sharepoint Site.

Thanx.

 

Regards,

Arthur

Thomas Lind
1 person likes this
  • Thomas Lind
    Thomas Lind

Reply


Most helpful members this week

Terms and ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings