cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

Dataflow Refresh Error - SharePoint Lists

Since 06/30/2020 my dataflows that connect to SharePoint data have failed and keep failing.

It apears the source (Name = have changed from Names to GUUID's.

Has anyone seen this?

 

ScottBrown_0-1593984960819.png

ScottBrown_2-1593985123465.png

 

 

If i connect to a new instance of the list as if I am trying to create a new dataflow, the Navigation parses a GUUID.

Than I can see the data fine.

 

ScottBrown_1-1593985097182.png

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User IV
Super User IV

Re: Dataflow Refresh Error - SharePoint Lists

Hi there

Could you look at this reference blog post and change the API version and see if this helps?

https://community.powerbi.com/t5/Issues/SharePoint-Folder-Connector-fails-for-API-15/idi-p/331819




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

5 REPLIES 5
Highlighted
Super User IV
Super User IV

Re: Dataflow Refresh Error - SharePoint Lists

Hi there

Could you look at this reference blog post and change the API version and see if this helps?

https://community.powerbi.com/t5/Issues/SharePoint-Folder-Connector-fails-for-API-15/idi-p/331819




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

Highlighted
Regular Visitor

Re: Dataflow Refresh Error - SharePoint Lists

I tried the API suggestion, no luck.  The issue is the Name scope changed on the backend by MS.  It only appears to recognize GUUID, not the SP list name.

Highlighted
Microsoft
Microsoft

Re: Dataflow Refresh Error - SharePoint Lists

Hi @ScottBrown ,

 

If you wan to change the datasource, you should ensure original steps can works on new source.(the steps which start from "Navigation")

 

For example:

Your original table name is "ImportTracker", but the new source not contain the "ImportTracker", it will show the error message which you mentioned.

 

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

Highlighted
Regular Visitor

Re: Dataflow Refresh Error - SharePoint Lists

Correct Llang,

 

However, the list name has not chaned.

If I create a new connection to the Same "Import Tracker" list, it shows up as a GUUID instead per the atatched pictures.

 

Nothing changed on my side during this period, but something changed on the back end - not from me.

Now, the refresh no longer works.

 

Highlighted
Regular Visitor

Re: Dataflow Refresh Error - SharePoint Lists

The same issue exists on all dataflow entities that connect to SharePoint lists.

All other data sources ie SQl, file, ACCess and such that we use still refresh.

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.

Top Solution Authors
Top Kudoed Authors