Error in Microsoft Applied Skills: Implement a Real-Time Intelligence Assessment Lab : Need help

[AshikaAlvakonda]

Hello All, since a week I was stuck on one error in Microsoft Applied Skills: Implement a Real-Time Intelligence solution with Microsoft Fabric Lab. Did anyone face the same issue if so, can anyone help me out how to resolve it. Attaching the error and related images below.

Error: It says " unable to load container blobs. Verify that workspace identity is enabled and has storage blob data reader access to the storage account" . I am familiar with this permission and have enabled it in my own azure environment for my own blob that I have created but since these are pre created by Microsoft, I don't have access to these storage blobs and hence I am not sure how to proceed here. I have attempted this twice but I was stuck at the same point.

I really appreciate your help and taking time in looking into my post. Thank you so much.

[stoic-harsh · Accepted solution]

Hey @AshikaAlvakonda,

Select Connect to a Storage Account option, and turn off Continuous Ingestion setting. Disabling it would hide the "Connection" placeholder, and you can easily connect to the blob1 container.

In the Assessment, the credentials that you sign into Fabric with, are already configured to access the required blob storage.

Note: In your latest message, where you disabled Continuous Ingestion, notice that you have selected SAS URL option.

Hope this helps!

Best,

Harshit

[AshikaAlvakonda]

This worked for me. Thank you for your answer 🙂

[stoic-harsh]

Glad, it worked for you!

Best,

Harshit

[AshikaAlvakonda]

Hi @svelde . Thank you so much for the response. Have tried disabling continuous integration but, it still says "please enter a valid url" because the "Blob Storage URI" given in the assesment is not a complete token(attached the image). We need to have the SAS key as well appended to it to form a complete SAS URL . So, may I know where did you get the token since you mentioned you were able to get the data into the table? 

[svelde]

Hello @AshikaAlvakonda 

In the test, my file is named:

This results in a CSV import:

Your SAS URL differs from mine. Double-check your SAS URL in the email.

--

If this answer helps you, a thumbs-up or marking it as the accepted answer is appreciated. All community members with similar questions will benefit by doing so. Your contribution is highly appreciated.

[AshikaAlvakonda]

Hi @svelde Thank you for the response. I tried it but it says "Please enter a valid token"(image below). SInce the given URI in the lab is not complete SAS URI it doesn't have a SAS token/key. May I know where did you get the correct SAS URI since you were able to load the data? Did you give the same "Blob Storage URI" given in the assessment? 

[svelde]

Hello @AshikaAlvakonda ,

welcome to the Fabric Community forum.

You are taking this applied skill: Implement a Real-Time Intelligence solution with Microsoft Fabric and you are blocked on the task that requires importing a CSV file from the Azure Blob Storage.

It seems your questions overlaps with this one.

Use the Get Data wizard button within the KQL database.

First, inside the wizard, select the right table and disable continuous ingestion.

This makes it possilbe to work with a SAS URL. 

Be sure to click on that plus sign:

From there, proceed with the rest of the wizard and import the data.

--

If this answer helps you, a thumbs-up or marking it as accepted answer is appreaciated. All community members with similar questions will benefit by doing so. Your contribution is highly appreciated.