Forum Discussion

Xarsas's avatar
Xarsas
New Member
3 years ago
Solved

DataSource Error in ODBC Connection

Hi All,   I've run into an issue with PowerBI drawing a scheduled refresh of our on premise server. The connection is fine, and data has been working flawlessly for abour a year and a half, but som...
Dataflow
  • Xarsas's avatar
    Xarsas
    3 years ago

    Hi v-yueyunzh-msft 

     

    Thanks for the reply.

     

    A new data connection has the same issue. I created a second ODBC connection in Windows to test as well and that had the same issue.

     

    I can't find a place to see where exactly Power BI has the issue though, as in which column or row to narrow down the problem finding. This connection acceses a database from an ERP system, and the table is operating fine in that system so obviously sometime in the last two weeks some data field was changed/updated in a way that is casuing Power BI to hit a snag. 

     

    I'll have to trawl through the audit trails to find whatever caused it then, was just hoping there was a way to pinpoint in Power BI.

     

    Regards,

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Guys,

 

I'm having a different issue, whereby i unble to access ODBC from Power Bi desktop app in my server.

But i test the connection, able to establish.

only via power Bi can't.

Urgently need help

Thanks.