Forum Discussion

009co's avatar
009co
Icon for Helper IV rankHelper IV
3 years ago
Solved

Create new KQL database - stuck on loading indefinitely after being created

I am going through one of the Fabric real time analytics tutorials https://learn.microsoft.com/en-us/fabric/real-time-analytics/tutorial-1-resources   I am having problems with the create new KQL d...
data engineering
one lake
  • Anonymous's avatar
    Anonymous
    3 years ago

    009co Can you try creating the DB with a different name instead of NycTaxiDB also remove &clientSideAuth=0

     

    Regards

    Geetha

     

009co's avatar
009co
Icon for Helper IV rankHelper IV
3 years ago

Thanks for reply GeethaT

 

Yes that is what I am doing. Here are screenshots:

 

Create new KQL Database

 

 

 

However instead of showing the detail page for the new KQL Database it gets stuck indefinitely on the Loading page.

 

 

If I try to go back to the Workspace and try to open the new KQL Database 

 

 

 

 

it gets stuck indefinitely on the Loading page.

 

 

I have not yet been able to create a KQL Database successfully in many many attempts.  It always gets stuck on the loading page and never goes past it.

 

Something in my Fabric instance seems to be off.

 

Anonymous's avatar
Anonymous
Not applicable
3 years ago

009co Can you share the URL of the loading page?

Regards

Geetha

  • 009co's avatar
    009co
    Icon for Helper IV rankHelper IV
    3 years ago

    I just tried creating new KQL Database as above and it gets stuck on loading. That page's url:

     

    https://app.powerbi.com/groups/0817e2db-1f14-458e-9f73-aafb5fea21d1/databases/9b950f27-6e36-4b13-81e4-04296f0bcbee?experience=power-bi&clientSideAuth=0

     

    Thanks!

     

    Edited to add: 

     

    I have another unresolved unrelated issue (see thread link below) where a very simple Dataflow Gen2 query also runs indefinitely / times out. Maybe related to this KQL Database issue? Possibly my Fabric instance is under resourced or otherwise degraded?

     

    https://community.fabric.microsoft.com/t5/Dataflows/Dataflow-Gen-2-dataflow-queries-with-PIVOT-long-running-never/m-p/3268122

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      009co Can you try creating the DB with a different name instead of NycTaxiDB also remove &clientSideAuth=0

       

      Regards

      Geetha

       

      • 009co's avatar
        009co
        Icon for Helper IV rankHelper IV
        3 years ago

        Simply removing &clientSideAuth=0 from the url string allowed the url to be resolved!

         

        I was then able to activate the database.

         

        Even after activating the database, if I try using the full url that includes &clientSideAuth=0 it then goes in to the endless loading.

         

        RE the &clientSideAuth=0 part of the url string:

         

        1) It is somehow being added to my url but it isn't for other people?

         

        2) It is being added to other people's url too but for some reason it works for them but not me?

         

        Thanks!