Forum Discussion

Paul1234's avatar
Paul1234
Regular Visitor
2 years ago

ParseJSON - how many rows does it check

I have a datasource that comes in as JSON from a survey. If there is no response to a specific question, the schema name doesn't come back at all, as opposed to returning with a blank response.   I...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Paul1234 ,

 

Is this multi-layer nested json? Please check the following link if it helps.
GitHub - vinej/PowerQuery: PowerQuey advanced
Solved: Expand custom column nested in JSON record - API - Microsoft Fabric Community

Best Regards,
Gao
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group

Paul1234's avatar
Paul1234
Regular Visitor
2 years ago

Thanks Gao, no it is not, the issue is I believe that this function is only scanning a certain number of rows to determine what columns to generate and my JSON doesn't return the schema name if there is no response to that question.