How to query my data correctly

[nhodges]

I have connected to my Cosmos DB data source and found that the data is set up in a way that I do not know how to query it so that it is usable. PLEASE HELP!

I will attach a photo. But basically each (what should be a single line) of data is its own table. It shows a record link that you can click into and then that is where you find the a single line of data with values.

I need a query that can take the data inside each record table link (shown in picture) and make it just one line of data.

It's a bit hard to explain but am attaching a picture and would be intrested in setting up a call to help show better. 

Best,

Noel

[ppm1 · Accepted solution]

Just hit the double arrow button at the top right of your column to expand your records.

Pat

[nhodges]

Worked perfectly Thank you so much!

[ppm1 · Accepted solution]

Just hit the double arrow button at the top right of your column to expand your records.

Pat

[nhodges]

I feel so silly Thank you! But now when I go to Close and Apply nothing is showing up in my fields pane. Do I have to do another step?

[Anonymous · Accepted solution]

Hi @nhodges ,

Did you mean when you click "Close&Apply" and go back to Power Desktop, there is no data displayed in data view?

Please check if this "Enable Load" is selected, if not, data will not be loaded in Power BI Desktop.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.