Forum Discussion

Sogi's avatar
Sogi
New Member
7 months ago
Solved

Sharepoint List Importing Problems

Trying to pull a online Sharepoint list into Power BI. I'm able to see the list in the preview but if I try to convert it into a semantic model or transform the data I get an error.   Below is the ...
Need Help
  • adudani's avatar
    adudani
    7 months ago

    Hi Sogi,

     

    Even though the error message looks like a UI/JavaScript failure (ImageHtmlManagerBase.ts), the root cause is almost never the UI. That message appears when Power BI fails to retrieve or expand the SharePoint list metadata, and the UI crashes while trying to render the preview.

    In other words: Power BI can see the list, but cannot materialize it into a table.

     

     

    Some potential solutions may be:

    1. The SharePoint site URL is slightly wrong. Instead maybe try:

    SharePoint.Tables("https://newnanga.sharepoint.com/sites/Maintenance")

    2. The list contains unsupported column types. These columns load in preview, but fail when Power BI tries to expand them, triggering the UI crash suggested. Can try:

    https://newnanga.sharepoint.com/sites/Maintenance/_api/web/lists/getbytitle('YourListName')

     

    3. You’re using the v2.0 SharePoint connector. Switching to the legacy connector often fixes the issue instantly. 

    The v2.0 connector is faster but much more fragile. It may break on:

    • Large lists

    • Lists with complex fields

    • Lists with hidden system columns

    • Lists with attachments enabled

     

    4. Permissions mismatch. 

    If this does not resolve the issue, Could you share if:

    • The SharePoint list column types ?

    • Double check that the site name is spelled correctly

    • Whether you’re using Power BI Desktop or Power BI Service ?

    • Whether the list is large (10k+ items) ?

    Mask any sensitive data necessary.
adudani's avatar
adudani
Memorable Member
7 months ago

Hi Sogi,

 

Even though the error message looks like a UI/JavaScript failure (ImageHtmlManagerBase.ts), the root cause is almost never the UI. That message appears when Power BI fails to retrieve or expand the SharePoint list metadata, and the UI crashes while trying to render the preview.

In other words: Power BI can see the list, but cannot materialize it into a table.

 

 

Some potential solutions may be:

1. The SharePoint site URL is slightly wrong. Instead maybe try:

SharePoint.Tables("https://newnanga.sharepoint.com/sites/Maintenance")

2. The list contains unsupported column types. These columns load in preview, but fail when Power BI tries to expand them, triggering the UI crash suggested. Can try:

https://newnanga.sharepoint.com/sites/Maintenance/_api/web/lists/getbytitle('YourListName')

 

3. You’re using the v2.0 SharePoint connector. Switching to the legacy connector often fixes the issue instantly. 

The v2.0 connector is faster but much more fragile. It may break on:

  • Large lists

  • Lists with complex fields

  • Lists with hidden system columns

  • Lists with attachments enabled

 

4. Permissions mismatch. 

If this does not resolve the issue, Could you share if:

  • The SharePoint list column types ?

  • Double check that the site name is spelled correctly

  • Whether you’re using Power BI Desktop or Power BI Service ?

  • Whether the list is large (10k+ items) ?

Mask any sensitive data necessary.
  • Sogi's avatar
    Sogi
    New Member
    7 months ago

    I was using the Sharepoint Online list connector which was causing the issue. Using SharePoint List allowed the data to be imported without issue.