User Profile
ShayanSiddiqueI
Frequent Visitor
Joined 8 months ago
User Widgets
Contributions
nested Array Issue in Mapping the key Values Part
I have a nested list of the array within the API Response in the Azure Data Factory. When I am mapping it with the column its is showing me null value instead of giving me the actual value which exist. Here rthe Product List Part part of the reposnse that I wanted to map "products": [ { "id": 1, "catalogItem": { "id": 1, "identifier": "1", "_info": { "catalog_href": "https://example.com/1" } }, "description": "1", "sequenceNumber": 1, "quantity": 1, "price": 1, "cost": 1, "agreementAmount": 1, "billableOption": "1", "agreement": { "id": 1, "name": "1", "_info": { "agreement_href": "https://example.com/1" } }, "locationId": 1, "businessUnitId": 1, "taxableFlag": false, "dropshipFlag": false, "specialOrderFlag": false, "phaseProductFlag": false, "cancelledFlag": false, "quantityCancelled": 1, "customerDescription": "1", "productSuppliedFlag": false, "invoice": { "id": 1, "identifier": "1", "_info": { "invoice_href": "https://example.com/1" } }, "warehouseId": 1, "warehouseBinId": 1, "calculatedPriceFlag": false, "calculatedCostFlag": false, "warehouse": "1", "warehouseBin": "1", "company": { "id": 1, "identifier": "1", "name": "1", "_info": { "company_href": "https://example.com/1" } }, "productClass": "1", "needToPurchaseFlag": false, "minimumStockFlag": false, "calculatedPrice": 1, "calculatedCost": 1, "_info": { "lastUpdated": "2026-01-01T00:00:00Z", "updatedBy": "1" } } ] I am trying the catlogitem.id and the the Same Format you can see here but still cant get an data in the rows of the SQL Table How to refrenece it or how to flat it?69Views0likes2CommentsData Agent is Having Issue Error Loading Data AGent Data Source
I have created a Fabric Data Agent connected ontology as a Data Source and Getting the Following Menioned Issue. I have cross check everything but there was no problem I can see dont now why I am getting this problem ANyone can help?59Views0likes1CommentRe: Fact Table Multiple Dates Relationship with Dimension Date
Showing all dates means that I wanted to show the dates that are connected with fk of the fact table with the dimdate date column. Using use relationship it is not giving me a way to show all dates in single table. Don't wanted to perform any aggregation on base of date just wanted to pick up the date column.1.1KViews0likes1CommentRe: DP 600 Exam Practice Assement Secure Module
Here's the Result of my Practice Assement. I gave it too much time that in my mind I think every question answer is inserted. But Keeping it aside as you can see that the what is the percenatage I am getting from Practice Assesment What Do you think Am I ready for the Exam or not?900Views1like1Comment
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.