topic Re: Real-Time Intelligence: Unable to Connect KQL Database to Blob Storage in Eventhouse and KQL

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

Surya057 — Sat, 02 Nov 2024 22:44:35 GMT

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

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

Anonymous — Mon, 04 Nov 2024 02:03:21 GMT

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.

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

Surya057 — Mon, 04 Nov 2024 08:50:06 GMT

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

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

Surya057 — Mon, 04 Nov 2024 08:52:09 GMT

Hi Anonymous

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

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

seethalakshmis — Tue, 05 Nov 2024 12:41:37 GMT

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.

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

Surya057 — Tue, 05 Nov 2024 17:27:53 GMT

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.

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

seethalakshmis — Tue, 05 Nov 2024 23:53:12 GMT

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?"

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

seethalakshmis — Wed, 06 Nov 2024 09:10:52 GMT

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.

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

ibraheemolasupo — Sat, 13 Sep 2025 17:19:31 GMT

This was helpul to me today. Thanks

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

biglimos — Sun, 09 Nov 2025 14:18:11 GMT

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.