Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

SharePoint list imported data issues in PowerBI

Hi Guys!

I'm trying to import a SharePoint list in PowerBI but I'm getting a hyperlinked data. See screenshot below:

 

Note: The data in the Sharepoint List is indeed a hyperlinked name. Is there any way that PowerBI only adds the name instead of it having "List" as an entry.

 

I also have a problem with the data imported in PowerBI. Is there any way that it reads the exact text which is in the Sharepoint List? See screenshot below:

 

I hope you guys can help me out! Thanks! 🙂

Need Help
Tutorial Requests

6 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    6 years ago

    What do you get when you expand the list using the diverging arrows in the column header?

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hey Greg,

      I clicked on it and chose "Expand to New Rows"

      It did extract what was inside the hyperlinked "List"

      However, it turned out to be just numbers. See below:

       

      I checked the SharePoint list and those numbers extracted were the numbers hyperlinked.

      However, I wanted it to be the name that is reflected in the SharePoint list instead of a number.

      Hope you can help. 🙂

      • Greg_Deckler's avatar
        Greg_Deckler
        Community Champion
        6 years ago
        What about RequestorStringID ? That sounds like a string...?