Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Dataflow Direct Query Error in Desktop

Hi, I have created a dataflow which ingest data from MYSQL DB. I have enabled the "Enhanced compute engine settings" and also Turned ON the enchanted compute engine for this dataflow so it can be accessed through direct query from desktop.

Now when I try to use DQ, it is throwing me an error saying "We couldn't connect to your DirectQuery data source or internal model, Please check your access etc etc..."

 

The Dataflow is refreshing fine in the service, Import method is also working fine 

 

Do you know if there is any specific settings I need to enable/change in Admin Portal?

 

Thanks in advance for your help.

Need Help
  • Syndicate_Admin's avatar
    Syndicate_Admin
    5 years ago

    There is a bug in 2020 dec version desktop

    I have reverted to Nov 2020 and it worked fine as suggested by Microsoft support agent.

11 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Yes, I did follow all these steps. I have tried with SQL server on premises also just to eliminate if it is anything to do with MYSQL but it also didn't work. I also tried connecting directly to the SQL server to the DQ and it worked. So definitely something to do with some sort of settings/firewalls so wanted to check if there is any specific things we need to be aware of as I can't see anything documented for this situation

  • parry2k's avatar
    parry2k
    Super User
    5 years ago

    Surely it is weird, I would open a support ticket, if Enhanced Compute Engine is on and also turned on for dataflow, it should work. It is saying check your access, not sure why when it works with import.

     

    I will open a support ticket.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Thanks parry2k , Do you know the process to open support ticket? Or you will be able to open? Do you need any other details like the full error code?

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Compute OnDQ Enabled SymbolDQ ErrorImport Mode Table Loaded

       

      Have seen just now the SQL Profiler log and got the below

      An internal error happened due to failed runtime assertion: AccessToken must be specified... The exception was raised by the IDbConnection interface. A connection could not be made to the data source with the Name of '{"protocol":"powerbi-dataflows","address":{"workspace":"*******","dataflow":"*****","entity":"*****"}}'.

       

  • parry2k's avatar
    parry2k
    Super User
    5 years ago

    Anonymous not sure, you have Premium and you can open the ticket thru azure portal or report an issue here.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      I am on Dec 2020 release, may be "Enhanced Dataset Metadata" is stopping something? Do you know if we can disable this feature? If so how? I am not able to see it in preview feature anymore as this might be generally available now?

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      I have seen it, I can't see anything stopping from what I am doing.

      Can you elaborate a bit on "Functional Limitations"?

      • v-lionel-msft's avatar
        v-lionel-msft
        Community Support
        5 years ago

        Hi Anonymous ,

         

         I'm sorry, please open a support ticket, I didn't reproduce your problem.

        create support ticket 

         

        Best regards,
        Lionel Chen

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Administrator
    5 years ago

    There is a bug in 2020 dec version desktop

    I have reverted to Nov 2020 and it worked fine as suggested by Microsoft support agent.