Forum Discussion

DerekTrujillo's avatar
DerekTrujillo
Frequent Visitor
7 years ago

Data - JSON - Lists - Records

I have an issue that seems really similar to others, but I can't seem to get to the results I want. I am trying to create a Power BI report based on data in a Sharepoint List.  The data is timeshe...
Need Help
Tutorial Requests
v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
7 years ago

Hi DerekTrujillo ,

 

Choose that list column, click "To table" butter under transform tab.

 

Best regards,

Yuliana Gu

DerekTrujillo's avatar
DerekTrujillo
Frequent Visitor
7 years ago

I think the problem is that there are more than one record in the list and even if I save them as a table - I loose any key attributes to join back to the original data.  This also needs to be on-going / repeatable for other data coming in.  Sometimes there will be 2 records in the list, sometimes 5, sometimes 3...etc. 

  • Ricardofaster's avatar
    Ricardofaster
    Frequent Visitor
    6 years ago

    Hi,

     

    Any updates on this? Could you deal with this problem?

     

    Thanks,

     

    Ricardo