Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
ComputerHabit
Helper II
Helper II

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.

ComputerHabit_0-1733781404437.png

 


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 3
Anonymous
Not applicable

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.

ComputerHabit_0-1733841241845.png


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.

 

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors