Forum Discussion
Error just started with odata query to SharePoint data
Hello,
I have a report I built months ago. It recently started having errors. It's a document library, it used to load just fine.
Now it errors when I hit the refresh button and when I click the link to see the errors it takes forever and never shows anything.
I'm not really sure where to look anymore.
I made a new report with just the one library loaded. Sample data loads. If I then update data in the report even with no other changes I get an error.
3 Replies
Hi ComputerHabit
Could you provide the corresponding error message? Without the error message, it's difficult to determine the cause.Best Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I let the PowerBI run and walked away. I came back to an error.
I'm not sure if RowID corresponds with the ID of the item in a Sharepoint library. I don't think it does.
And if that's the case I'm not sure how to get to the RowID since it's at such a large number.
I did turn on diagnostics and in the SessionDeviceInfo.txt file I found an error
Message = "The type of the value does not match the type of the column."
I'm still trying to determine what that mismatch might be since everything was working. I do have users that use French, Chinese, Japanese and other languages. So far it hadn't been an issue but I'm wondering if some illegal character made it's way into a title or something like that. Hard to tell yet.I wrote this but now I think that message was just a condition of the script I pulled it from and not an actual error.
