Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Json document data in power query

Hi all,  can anyone tell my which part of this Json code is worng? I am seeing an error in power query saying "  but I don't knwo how to fix it, here is the code  let Source = Json.Document...
General Comment
Need Help
Tips and Tricks
v-yingjl's avatar
v-yingjl
Icon for Community Support rankCommunity Support
4 years ago

Hi Anonymous ，

Please check whether the query could return the correct result

PrimaryQueryResult = Source[PrimaryQueryResult],

If not, it could be caused by the Source query, try to use Relative path and Query options in Web.Contents() to adjust your source query.

 

You can refer this blog which introduces it in details:

Using The RelativePath And Query Options With Web.Contents() In Power Query And Power BI M Code 

 

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.