Forum Discussion

ivanuska's avatar
ivanuska
Advocate I
2 years ago
Solved

Sharepoint list - suddenly table is empty

Hi guys,

 

I would need your help - from 15th of March I am not able to see data in one of my Sharepoint lists that is being imported to Power BI.

 

I have the access to the list using my company O365 account that is also used for connection. The thing is that I can see table in Power BI however if I expand the items I got "This table is empty" notification. 

 

There is no filters applied in Query editor.

 

Sharepoint list itself containc 1500+ entries. Until 14th of March, data were loaded with no issue.

 

What might cause the sudden issue?

 

Thank you for any help.

Ivanuska

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi all,

    Our engineers have solved this issue, if there are any follow-up questions, please leave a comment below. Thanks!

    Best Regards,
    Dino Tao
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

23 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    ivanuska 

     

    I don't have any solutions as of yet, but I wanted to highlight that the exact same thing happened to a couple reports I maintain, each using lists from different SharePoint sites. I maintain quite the catalog, but it so far the only issues have been with two SharePoint sites. The other thing is, this all fell apart on 3/14/24 as well.

     

    Definately someting Microsoft needs to look into. Hopefully we get more eyes on this. I created a new list on one of the SharePoint sites and was able to get data from that, but the original that currently houses all the data still comes up empty. I hope there is some sort of resolution because I don't want to have to clone the SP List and redo everything.

    • ivanuska's avatar
      ivanuska
      Advocate I
      2 years ago

      Thank you Anonymous for confirming the issue. I have created support ticket and will come back once I will have any news.

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        I can confirm this same issue on my end as well. My list requires that users have limited visibility. A solution without having to adjust this setting would be ideal. Will be on standby to learn more!

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      I too have had this problem. I can see all the data in the list itself perfectly, but PBI just tells me the table is empty now. Everything was fine until late last week. Would be interested to hear of what the resolution is

      • ivanuska's avatar
        ivanuska
        Advocate I
        2 years ago

        Hi Anonymous ,

         

        as indicated by DenisW , in Advanced settings you can switch Item Level Permission to "Read all items" if records in the list can be seen by all list users.

         

  • DenisW's avatar
    DenisW
    New Member
    2 years ago

    Dear invanuska,

    we had the same problem.

    We solved it in the List-Settings of the list.

    Goto the "advanced settings" -> "Item level permission" and check if "Read access" is "Read all items" :

    Hope that helps.

     

     best regads Denis

    • ivanuska's avatar
      ivanuska
      Advocate I
      2 years ago

      Hi DenisW ,

       

      after changing settings it will become visible in Power BI. However, the owner of the Sharepoint list requires this settings not to be changed.

       

      I will pass this valuable information to Microsoft within the pending support ticket.

       

      Thank you

      • M4teusz's avatar
        M4teusz
        New Member
        2 years ago

        Hi,

        Any response from Microsoft Support? I have similar problem and I am looking for possible solution without changing SharePoint settings.

         

        Thanks

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi all,

    I apologize for the inconvenience, our engineers have confirmed that this is a known issue and are already attempting to resolve the issue, as soon as there is any progress I will respond at the bottom of the thread.
    Again, I apologize for the inconvenience!

    Best Regards,
    Dino Tao

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi all,

    Our engineers have solved this issue, if there are any follow-up questions, please leave a comment below. Thanks!

    Best Regards,
    Dino Tao
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • jtao's avatar
    jtao
    Helper I
    2 years ago

    Hi ivanuska,  I also found this issue since 15/3/24 at 7AM when the semantic model refresh failed. Then I used PowerBI desktop to connect to two Sharepoint lists which came back with empty table. 

  • LubanaM's avatar
    LubanaM
    New Member
    2 years ago

    Yeah, it happened with me too. all of sudden SharePoint list imported via Power Query into PowerBI reports are showing empty. it is really strange that few of the SharePoint lists are working and few have this issue. I would like to keep the setting as i want users to view their data only.

     

    Kindly let me know any update on this issue, Standby till then!

  • nellekekb's avatar
    nellekekb
    New Member
    2 years ago

    I'm also experiencing the exact same thing for two of my lists since March 15th when the reports started to fail to refresh. 
    Is it useful to raise a support ticket to speed things up? I also really need this to be fixed without changing the visability setting.

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      nellekekb Please see the message from Anonymous from Microsoft. It does sound like the engineers are aware and workin the problem. I doubt more tickets would do anything at this point, but you do you. Hopefully this is resolved soon.

       

      Thanks all!

      • ivanuska's avatar
        ivanuska
        Advocate I
        2 years ago

        Hi everybody,

         

        Microsoft support team has just advised sharepoint team applied another changes that should fix the issue.

         

        I have tested the refresh on my Sharepoint list and the refresh was successful.