Unable to load data from ADLS Gen2 into KQL database using "Get Data" option

[ananthkrishna99]

Hello Community,

I'm trying to load data from "ADLS Gen2" into "KQL Database" using "Get Data" using the available "Get Data" option. I can preview the data, but when I tried load I'm getting "Failed To Ingest" with details as "Failed to download blob: Provided credentials cannot be used to access the persistent storage". I'm owner of the "ADGLS Gen2" and I also have "Storage blob dta contributor" permissions too. 

When I tried to load using a "Data Pipeline" it is succeded. Can you please let me know how to fix this issue?

Thank You.

[Anonymous]

Hi @ananthkrishna99 ,

Please check if you have a storage account?

Create an Azure storage account - Azure Storage | Microsoft Learn


Again, please check that the credentials you provided are correct:

https://learn.microsoft.com/en-us/fabric/real-time-intelligence/get-data-azure-storage#configure 
https://learn.microsoft.com/en-us/kusto/api/connection-strings/storage-connection-strings?view=azure... 

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

[ananthkrishna99]

Hi @Anonymous 
Thanks for your reply, as I mentioned I have the storage account and I'm both owner of the storage account along with Storage blob data contributor permissions. I'm trying to connect with my account not with SAS/ account key and also as mentioned in the above snippets I can see the preview of the data but I'm getting the error when I tried to load it.

[Anonymous]

Hi @ananthkrishna99 ,

I really can't reproduce the problem.

I suggest you open a support ticket to get more detailed information and a dedicated Microsoft engineer will come to solve the problem for you.

The link of Power BI Support: Microsoft Fabric Support and Status | Microsoft Fabric

For how to create a support ticket, please refer to How to create a support ticket in Power BI - Microsoft Fabric Community

Best Regards,
Dino Tao