Unable to retrieve data from reference dataset in Azure Stream Analytics

James 0 Reputation points
2023-04-28T20:16:53.94+00:00

I am trying to run my first Azure Streaming Analytics query:

User's image

But when I test the query I get the message "There is no data from input 'referencedata'. Please make sure the input source has data and then try again."

The reference dataset is in an ADLS Gen 2 account.

My reference dataset details:

User's image

The storage location:

User's image

The data:

User's image

Please advise.

Azure Data Lake Storage
Azure Data Lake Storage

An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.

Azure Storage
Azure Storage

Globally unique resources that provide access to data management services and serve as the parent namespace for the services.

Azure Stream Analytics
Azure Stream Analytics

An Azure real-time analytics service designed for mission-critical workloads.

3 answers

Sort by: Oldest
Most helpful Newest Oldest
  1. Sander van de Velde | MVP 37,081 Reputation points MVP
    2023-05-01T23:01:18.04+00:00

    Hello James,

    I see you are using a Blob storage with the year/month/day path format.

    In the past, I also worked with reference data and I used the Time field too.

    Can you add an extra level to the path for the hour? The sub path '00' will do already.

    You need to change the path pattern too.

    If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. All community members with similar issues will benefit by doing so. Your contribution is highly appreciated.

    Was this answer helpful?

    0 comments
  2. Shelly Chen 0 Reputation points
    2026-02-27T20:58:06.4166667+00:00

    Hi thank you for posting this, I am running into exactly same situation now, any idea how did you resolved this back then? my file path is {date}/{time}/TMS.json, I also tried directly use TMS.json, but neither worked out. Once the start the job, nothing made to my destination. Any insight would be appreciated. Thanks!

    Was this answer helpful?

    0 comments
  3. Shelly Chen 0 Reputation points
    2026-02-27T20:58:24.7833333+00:00

    Hi thank you for posting this, I am running into exactly same situation now, any idea how did you resolved this back then? my file path is {date}/{time}/TMS.json, I also tried directly use TMS.json, but neither worked out. Once the start the job, nothing made to my destination. Any insight would be appreciated. Thanks!

    Was this answer helpful?

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.