Forum Discussion

moeinsql's avatar
moeinsql
Regular Visitor
8 years ago

OData exception

Hi dear  I have power bi reporting server (august 2018) that connect to sqlserver 2012 and generate some report on portal prpperly. when i want to create reresh plan. the error somting went wrong o...
moeinsql's avatar
moeinsql
Regular Visitor
7 years ago

I can see and render report currectly and also can define datasoure for report. I've edited execution account with proper U/P (sqladmin) that connect to database  successfully.

Also it's worth mentioning that an sql server database set to windows authentication mode.

 

data needed for report come from one table in database and in power bi desktop it's set to import mode.

mgmeyer's avatar
mgmeyer
Power BI Team
7 years ago

Can you upload/render and RDL report? Can you check the ReportingServicesLogXXXX in your LogFiles folder and see if you are getting any errors?

  • Wanderson27104's avatar
    Wanderson27104
    Regular Visitor
    2 years ago

    How did you finally fix this problem.  I am getting the same odata error with Power BI Report server September 2023 release.  Works on my desktop version of the report server but getting the error when going to a server.