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
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.

  • aj1973's avatar
    aj1973
    Community Champion
    3 years ago

    Well done, I now remember that step. I had to do it for a client few months ago but couldn't recall it for this thread.

    Good job cisaemp