cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RichardNelson Frequent Visitor
Frequent Visitor

Connection to a Sharepoint Online list has stopped working (Password correct!)

Hi All,

 

New here so advance appologies for a possibly newbie question, but I have failed to find a solution already posted.

 

I have a PowerBI Report that pulls data from a SharePoint Online (Office365) list.

 

This was working fine until 23/6. Initially it failed with a "Credentials error", since resolving that I now get the following :-

 

"There was an error when processing the data in the dataset"

 

If I expand it for details it says :

 

"The operation is cancelled by the user"

 

 Along with the Cluster URI, Activity ID and Request ID (for some reason Edge is refusing to let me paste these using CTRL+V)

 

The list structure/fields have not been changed since creating the PBi Report, other than additional items being added to it.

 

As I'm new to PowerBi at something of a loss as what to do next, so would be greatful for suggestions.

 

Thanks in advance.

 

 

 

 

 

 

4 REPLIES 4
adrianbravo Regular Visitor
Regular Visitor

Re: Connection to a Sharepoint Online list has stopped working (Password correct!)

Hi,

Do you have Power BI Pro ?

Moderator v-yuezhe-msft
Moderator

Re: Connection to a Sharepoint Online list has stopped working (Password correct!)

Hi @RichardNelson,

"The operation is cancelled by the user"

Based on your description, the above error occurs after you add additional items to SharePoint online list. The issue could be caused by that there are erroneous values like #N/A, #NA and so on in data columns, or there are duplicates in your data source.

I would recommend that you connect to SharePoint Online list from Power BI Desktop and check if it works as expected. Also you can pull your data to Excel to check if there are any illegal characters/values and duplicates.

Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
RichardNelson Frequent Visitor
Frequent Visitor

Re: Connection to a Sharepoint Online list has stopped working (Password correct!)

Hi Adrianbravo,

 

No - the standard version. We did have a trial of Pro, but this ran out in Febuary. The issue started in June.

 

Richard

RichardNelson Frequent Visitor
Frequent Visitor

Re: Connection to a Sharepoint Online list has stopped working (Password correct!)

Hi Lydia,

 

The fields are almost all text rather than numeric, and there are some blanks, but these appear in records created before the date the data refresh stopped working as well as afterwards.

 

The list has a "reference number" as the first item - this does not appear to have any duplicates - an export and inport into Excel works fine.

 

Richard

Helpful resources

Announcements
GregDeckler

How to Get Your Question Answered Quickly

Power BI Super User, Greg Deckler, explains

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Ideas
Top Kudoed Authors
Users Online
Currently online: 41 members 923 guests
Please welcome our newest community members: