Forum Discussion

009co's avatar
009co
Helper 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

     

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
Helper 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
      Helper 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!