Sharepoint connection - data are not as expected

[peisenrot]

Hello, 

I have one sharepoint connector set up and can load the data from there. For all fields where we have a list behind I see only the number of the field 

how and where do I need to change something that he is loading not the number but the text which is visible in sharepoint.

Best regards

Pia

[wyaneb1]

if you go to Excel online and then access the file and get the file path from there it should have a full file path with sharepoint extension.

i use Power bi but i think it’s the same way but i use the get data from Web and put in that path.

hope that helps

[Turmanw3]

Thank you share this information & post.

Tellthebell