Query Editor Issue

[hitty08]

Good afternoon everyone,

I am haveing a issue querying the particular data I need from a SharePoint API. I can get the data into the query editor, but each object is listed in an individual table.

indx     Content

1          Table

2          Table 

3          Table

How dod I merge all those tables into one query, I can drill down to see all the data about the idividual object, but I can not seem to merge them all as one in order to use the data within PowerBI.

Thank you for any help!

[Anonymous]

A few questions.

How is your data arranged in Sharepoint API? Is it one table like you want it to be? 

Do your tables have related fields? If so you don't need to merge them all together.

Without sample data it's a little tricky to navigate your issue. 

[hitty08]

it is a sharepoint list, the data is arranged how I want it and I have an API for it. I have also tried to ingest the api using the odata feature, but I get an error 404.