Forum Discussion

dvdbroek's avatar
dvdbroek
Frequent Visitor
5 years ago
Solved

Getting a specific value from a table that comes from a JSON file into a variable

Dear M query king and queens, I made a custom function that retrieves an API Acces key so i can retrieve data from an API. The code is as following:       (UserName as text, OfficeCode as text,...
Need Help
  • dvdbroek's avatar
    dvdbroek
    5 years ago

    Anyone who can help me?

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi  @ dvdbroek ,

 

This is related content, hope it can help you:

https://radacad.com/analyse-the-json-file-with-power-query

https://community.powerbi.com/t5/Desktop/Parsing-JSON-data-into-PowerBI-table/td-p/55946

https://eriksvensen.wordpress.com/2014/09/15/specifying-json-query-in-power-query-example-statistics-sweden/

 

Best Regards,

Liu Yang

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