Forum Discussion

cisaemp's avatar
cisaemp
Regular Visitor
3 years ago

There was an error when processing the data in the dataset from SharePoint

Hello!   I have a Power Bi report getting data from SharePoint.  Everything works fine in Power Bi Desktop, but this weekend the automatic refresh from Power Bi Service has an error when processing...
Need Help
MikeLach's avatar
MikeLach
New Member
3 years ago

This same problem started for us on Friday evening as well. The ID column is there in the SharePoint Online list, it is there in the data after the import, and any refresh done of the dataset in the desktop app works successfully. However, after publishing the dataset to our workspace the refreshes fail with the error mentioned above.

  • aj1973's avatar
    aj1973
    Community Champion
    3 years ago

    MikeLach cisaemp 

    Could you guys republish the dataset into another workspace and try again ? 

    This thing is indeed weired !

    I tried it on my tenant and it is working fine. 

    • cisaemp's avatar
      cisaemp
      Regular Visitor
      3 years ago

      Yes, I republished the dataset into another workspace, but didn't work.  I tried the following and worked:

       

      In the first step of the query, Source, I selected the following settings to bring all the columns from the SharePoint View. Before, I added the ID column in the SharePoint View of the list.  The other option, All - Retrieve all Columns works too and you don't need to add the ID column to the View.

       

      Then, I choose the columns that I need for the report including the ID column.

      Then, Close & Apply the query and Publish. I tested in the Power Bi Service and started to work and I activated the Schedule Refresh. 

       

      Thanks all for your help!

       

      Edgar

      • MikeLach's avatar
        MikeLach
        New Member
        3 years ago

        cisaemp stated: "The other option, All - Retrieve all Columns works too and you don't need to add the ID column to the View."

         

        This does not work for me - I have always been using the "All Columns" option from the beginning before this problem started.

    • MikeLach's avatar
      MikeLach
      New Member
      3 years ago

      Published to a personal workspace and the same issue exists.

  • PBI_Queryous's avatar
    PBI_Queryous
    Advocate I
    3 years ago

    I'm having the same problem. PBI Service is lying to us. The ID column exists, and PBI Desktop refresh works fine. The PBI Service claims it can't find the ID column, even though this column isn't referenced in the M-code.

    This is definitely a MSFT bug.

    • aj1973's avatar
      aj1973
      Community Champion
      3 years ago

      PBI_Queryous 

      The solution is here in the message  7 of 11, read it please 

      • PBI_Queryous's avatar
        PBI_Queryous
        Advocate I
        3 years ago

        Thanks aj1973 - 

        It seem's you need to change the ViewMode to "All" instead of "Default".

        Also - you MUST select the ID column, for some reason it doesn't let you unselect this column. I don't recall this being a limitation before?

        Kindest regards,
        PBI Queryous