Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Converting a JSON list of lists into a table

Howdy,

 

A data service I work with was supposed to solve all my problems with their PowerBI connector but when I use it I am unable to create a scheduled refresh on my reports. Therefore, they suggested I load their data in as a JSON and then it should be able to refresh. However, I am not technically savvy enough to figure out how to convert this List of Lists into a usable table using methods in other forum posts.

 

What I am seeing

 

 

The very first list contains the column headings and each other list contains the row contents. How do I parse this out to something usable? 

Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi Anonymous,

     

    You can convert that list to Table, Click on Into table, then start expanding the value till you find all the records.

     

    Thanks,

    Amit

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Anonymous,

     

    You can convert that list to Table, Click on Into table, then start expanding the value till you find all the records.

     

    Thanks,

    Amit

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hey Amit, thanks for your response. I got it to work :manhappy:

       

      Still didn't solve my scheduled refresh problem but I got JSON to work at least!

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Hi Anonymous,

         

        Can you tell me how you want to schedule your reports?

        In general, You can go to dataset in Power BI service , select the workspace then select Schedule refresh or schedule now for any datasets.

         

         

        Thanks,
        Amit