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 sug...
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

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

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hey Anonymous ,

       

      I am workign with a service which is taking my Social Media data and converting the networks API into a weblink that can be handeled by PowerBI. However, when using that weblink as a datasource, I am unable to set scheduled refreshes:

       

       

      When I reached out to the service for support they indicated that by processing the data as JSON instead of their PowerBI specific link should solve the issue... but it did not. Next thing to try is setting up a gateway but its strange because I didn't think I needed a gateway for data from the web.