Jump to content

Error on reporting using Power BI


Recommended Posts

  • Victor changed the title to Error on reporting using Power BI

@Darren Rose @Victor,

I've not come across this issue before, but a quick Google shows that lots of other people have seen this error when using all different data sources (not just R, but using SQL, CSV, XLS etc). It's not an issue with our import scripts, it's a problem with Power BI itself. Seems that the data type of one of the columns doesn't like the data being presented to it, hence the type mismatch error, so the affected column type will need to be changed in the query editor in Power BI. Take a look at this thread for more information:

https://community.powerbi.com/t5/Desktop/Data-refresh-error-OLE-DB-or-ODBC-error-Exception-from-HRESULT/td-p/39691

If you can't identify which column is causing the issue, then you may need to delete the table in Power BI and re-import the data. Hopefully, it won't come to that though!

Let me know how you get on with this.

Thanks,

Steve

 

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...