microsoft / studentambassadors

This repository is for Microsoft Learn Student Ambassadors.
MIT License
130 stars 47 forks source link

Couldn't infer file schema<Data Analyst> #209

Open abimelsbk opened 1 year ago

abimelsbk commented 1 year ago

Describe the bug

Couldn't infer file schema while ingesting data from blob storage into KQL database.

Severity : Medium

Persona : Data Analyst

reference: https://learn.microsoft.com/en-us/fabric/real-time-analytics/get-data-blob

What happened?

I had created a KQL Database and clicked Getdata and select Blob from the list to ingest data. I created a table name, and selected blob as source. I had copied the SAS Url from azure storage account and pasted as source. The error shows when I moved to the next section called schema.

image

Error

Couldn't infer file schema. Error: Request is invalid and cannot be processed: { "error": { "code": "BadRequest_MissingBlobName", "message": "Request is invalid and cannot be executed.", "@type": "Kusto.Cloud.Platform.Storage.PersistentStorage.PersistentStoragePathGeneralException", "@message": "Error with persistent storage path 'https://createfbdatabase.blob.core.windows.net/fabcont' (operation 'CreateFileRef'). Extended error information: 'Blob name not specified'",

What did you expect to happen?

The page I expected was similar as the one below.

image

I expected to see partial data preview of the ingested data and normal navigation to the next section (Summary)

How would you reproduce the bug?

  1. create a KQL Database
  2. clicke Getdata and select Blob from the list
  3. created a table name
  4. select source type : blob
  5. go to azure portal and copied the SAS Url from azure storage account
  6. Paste it as source into the input for Link to source

Did this happen via Desktop and/or Smartphone?

No response

Operating System

Windows 11 Pro

What browsers are you seeing the problem on?

Microsoft edge

Version

No response

Device

HP Pavalion

What is your current role?

Student Ambassador

What technical topic is this bug related to?

Data Analyst

Relevant log output

Couldn't infer file schema. Error: Request is invalid and cannot be processed: {
    "error": {
        "code": "BadRequest_MissingBlobName",
        "message": "Request is invalid and cannot be executed.",
        "@type": "Kusto.Cloud.Platform.Storage.PersistentStorage.PersistentStoragePathGeneralException",
        "@message": "Error with persistent storage path 'https://createfbdatabase.blob.core.windows.net/fabcont' (operation 'CreateFileRef'). Extended error information: 'Blob name not specified'",
github-actions[bot] commented 1 year ago

Thank you for submitting this issue! The team will review your issue, tag with the appropriate tags, and comment with any additional questions on information needed. :sparkles: