Data ingested into ADME via Synapse Full data load with Power BI

[kevbor]

Hi, I have ingested binary data into ADME via synapse using the following guide (https://github.com/EirikHaughom/ADME/blob/main/Guides/Synapse/DataLakeIngestion/deploy-mi.md) . I have ingested both CSV and JSON files into our ADME instance and validated that I can retrieve the data using a CURL function and the corresponding pipeline run ID as listed in the validation portion of the document above.

While connecting to our ADME instance via Power BI, i noticed that we can only see one record on the ingested dataset, however while ingesting a data via postman we can see all records. Do you have an idea how we can see the full dataset in PowerBI after ingesting the data into ADME with Synapse?

Thanks!

[Miller-Kyle]

Hi @kevbor - can you please include some screenshots? When the data comes back what does the table look like?

[kevbor]

Hi @Miller-Kyle

I have added screenshots here

Source CSV

Pipeline Success with run ID number

ADME response with CURL function as seen in the validation segment of the guide in the original post

Power BI, shows we have the same record ID as in synapse

Results in Power BI when expanding the data