Real-Time Intelligence: Unable to Connect KQL Database to Blob Storage

[Surya057]

Hi everyone,

I have a simple CSV file stored in Azure Blob Storage. I'm trying to read this data from my KQL database. I created the table by using the "Get Data" option in the EventHouse ribbon.

Unfortunately, I am unable to connect to the storage account. There are no firewall rules or VNet restrictions in place, yet I’m receiving the following error:

Error - 

Invalid URL. Either the URL leads to a blob instead of a container, or the permissions are incorrect. If you just granted permission, please wait a couple minutes and try again.

Url - https://fabconnector.blob.core.windows.net/data
container name is "data"

I am following this MS wiki for guidence - https://learn.microsoft.com/en-us/fabric/real-time-intelligence/get-data-azure-storage

[biglimos]

Big Limos is a leading manufacturer of luxury stretch limousines and custom vehicles. Big Limos combines expert craftsmanship, advanced technology, and elegant design to create premium vehicles that deliver unmatched comfort, performance, and style.

[seethalakshmis]

Is there a way to access Azure blob without any tokens ?  when I attempted to access a blob storage to load the data into KQL Database table in Real time intelligence in an Applied skills credential assessment for Real time intelligence I could not. They have not provided any access token or SAS token to access the storage blob.

[Surya057]

I faced the same problem with Applied skills but I was able to see the data and it failed in the last stage before completing the ingestion.  Next time I am planning to copy paste the blob url in browser and get the SAS token. I will share my results here after completing my next applied skills.

Please let me know if you found a workaround.

[seethalakshmis]

let me know whether you are able to take up the skill assessment and get the data loaded from Azure storage in the lab environment set up inside VM.

[Surya057 · Accepted solution]

Hi Everyone,

I just noticed, supported authendication is either SAS token or access token for Microsoft Fabric Kusto to access data from blob storage. After using the SAS token I can access the data in KQL DB in MS Fabric.

Regards,

Surya

[seethalakshmis]

It did not happen in my Fabric account. It happened inside a VM during the Applied skills credentials assessment. In the instruction emails, they just provided Blob storage URI and csv file name and not any token details. I was able to see the data preview during the Get Data phase, but could not complete it as in the summary it gave a Red Exclamatory mark and could not finish the process. So my question is " how to get the SAS token in the assessment environment?"

[Anonymous]

Hi @Surya057 ,

As mentioned in the error message, please check the URL and permissions. If you are using a Shared Access Signature (SAS) token, make sure it has the necessary permissions (Read and List) for the container. Add the blob URI for each storage resource. You can add 10 blobs, each blob a max 1 GB uncompressed. 

Each storage type has a different connection string format. See the following table for connection string templates for each storage type.

For more details, please refer: Storage connection strings - Kusto | Microsoft Learn

Best Regards,

Neeko Tang

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

[ibraheemolasupo]

This was helpul to me today. Thanks

[Surya057]

Hi @Anonymous 

Thank you for your kind reply. I managed to solve this after using the SAS token. I appreciate your support.