Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have a report that refreshes daily, it has been working fine for 3 months. Today, it showed me an error while connecting to a SharePoint List. The report also uses other 3 lists from the same site as data sources and those didn't have a problem.
I tried creating a new report on my desktop and connecting to the list, but the same problem showed. I know that my credentials are correct.
DataSource.Error: SharePoint: Request failed: The remote server returned an error: (400) Bad Request. (Value does not fall within the expected range.)
Any ideas?
Hi @Anonymous ,
This error is usually thrown when the value being set for a column doesn't conform to its type and limits. For example, you might be updating a Number column with a string value or a value that exceeds the SharePoint number column limit.
This issue might occur when you are creating/updating listitem having Number, Choice, Lookup, People, DateTime columns.
Please check the data source and confirm whether the above situation exists.
I tried the suggestions with no luck. I think the problem is not the connection to SharePoint but with the data. I was able to select the list but when I go to "Transform data", it seem to be an issue when I try to download more than 100 rows. It also shows an Error in line 101. If I keep the first 100 rows, the error is gone.
What I don't understand is whyyesterday I had no problem since the Sharepoint List hasn't been updated recently
HI @Anonymous ,
Did you check the following similar thread for this issue?
https://community.powerbi.com/t5/Service/Problems-connecting-to-on-prem-sharepoint-list/td-p/196293
If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂
Thanks,
Pragati
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |