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