Forum Discussion

Baykus's avatar
Baykus
Frequent Visitor
2 years ago

ODBC: ERROR [08S01]

Hi community. 

 

I am receiving ODBC: ERROR [08S01] in 2 ways:

 

1- while I am adding a new table in Power Query Editor,

 

 

2- or I receive same error code after I add table in power query, then apply steps for the tables in report pages.

 

 

 

Is there a solution for this error? I didnt get used to receive this error before and all my same files were working well even the data soruces and everything were same with now. I checked my table sql queries in Dbeaver and it works well. So the problem seems related about power bi, not about query performance.

 

I also tried to create tables on online version with same odbc sources and sql queries, but then I received below error this time:

 

 

"Evaluation was canceled, message: Evaluation was canceled, message: Evaluation is canceled (Session ID: d4b7ac73-df30-4fd8-9b92-d2c3cf48ccfd, Region: us)"

 

Do you have any suggestions how I can continue to work on desktop version with big data sources?

 

Thanks in advance to everyone who reply!

 

Nilay

 

 

Need Help

4 Replies

    • Baykus's avatar
      Baykus
      Frequent Visitor
      1 year ago

      Hi rajendraongole1,

       

      There is not a solution in your refered thread loop answers. Do you have any other theads? I have already searched for same issue and solution in community but couldnt find any solution. 

       

      Many thanks

      Nilay

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi,rajendraongole1 ,thanks for your concern about this issue.
    And I would like to share some additional solutions below.
    Hi,Baykus .I am glad to help you.

    Are you using the latest version of Power BI Desktop?
    Our team has noticed that there is currently an error when connecting to a data source using ODBC for newer versions of Desktop, and the temporary solution is to download a historical version of Desktop to circumvent this issue.

    You mentioned that you have not had similar problems with previous versions, and that you have tried several ways to verify this, and that the same problem occurs in all of them. It is possible that there is an unexpected error in Desktop itself.

    We are now looking into the issue regarding the error with the ODBC connector and I will update this issue if there is an update.Thank you for your support of Power BI.

    Links to download historical versions of Desktop
    Previous monthly updates to Power BI Desktop and the Power BI service - Power BI | Microsoft Learn
     

    I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
    Best Regards,
    Carson Jian,
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Baykus's avatar
      Baykus
      Frequent Visitor
      1 year ago

      Hi Anonymous, Thanks for your suggestion. I will install June 2024 version of Power BI Desktop - 64-bit. I will see if it works. 

      However, I found a solution by dividing sql query in to 3 query for per email group. So I didnt use union. Then I append 3 table and it worked! It is so wierd to me and didnt understand the reson how applied steps can be working while an sql query is not. The hole query with union was working before but has started to give the error [08S01]. It doesnt make sense to me but it is working now 🙂