Forum Discussion

Vickar's avatar
Vickar
Advocate II
3 years ago
Solved

Power BI RS Desktop stuck at Evaluating Query for Custom SQL Query

I am importing data from  Oracle DB, when I connect to base tables from the source, I am able to successfully load data into PBI RS Desktop. But when I write custom sql code, I am able to see the da...
Data Load
  • Vickar's avatar
    Vickar
    3 years ago

    Yes. I had installed ODAC 19 earlier due to which I was facing this issue. Microsoft Power BI Support Team recommended to uninstall it and install the ODAC 12 version. And it worked.

Vickar's avatar
Vickar
Advocate II
3 years ago

I am able to see the query results in Power Query window, and for testing purposes, I am using a simple SELECT statement with 10 rows only.

 

I've also opened a support ticket with Microsoft. 

RobC84's avatar
RobC84
New Member
3 years ago

was there a solution to this one?

 

  • Vickar's avatar
    Vickar
    Advocate II
    3 years ago

    Yes. I had installed ODAC 19 earlier due to which I was facing this issue. Microsoft Power BI Support Team recommended to uninstall it and install the ODAC 12 version. And it worked.