Data not appearing in PowerBI

[rsmccall33]

I have Application Insights running in an environment that is capturing server and client side telemetry.  I then have continuous export setup to blob storage as json.  I then have Stream Analytics polling data from the json and streaming to PowerBI. 

I have done this successfully for PerformanceCounters, however, the Availability content will not show up in PowerBI.  I created a completely new Stream Analytics job with it's own input & output & query specifically for Availability.  All connections are successful.  I tested the query against sample data and it returns a table that I expect to see.  However, I start the job and wait...and wait...and wait...and nothing ever appears in PowerBI.  When I did this for PerformanceCounters it showed up in PowerBI almost immediately. 

I've fiddled around with the query but I'm not strong in this area so I'm more-or-less guessing.  Below is the query. 

SELECT
    flat.arrayvalue.testName as testName,
    flat.arrayvalue.runLocation as runLocation,
    flat.arrayvalue.result as result,
    flat.arrayvalue.availabilitymetric.name as metricName,
    e.context.location.continent as continent,
    e.context.location.country as country,
    e.context.location.clientip as clientIP,
    e.context.location.province as province,
    e.context.location.city as city,
    e.context.data.eventTime as eventTime
INTO
    availabilityOutput
FROM
    availabilityInput AS e
CROSS APPLY GetElements(e.availability) as flat

[rsmccall33 · Accepted solution]

I built everything in Central US because that is the only location option when building the Application Insights environment.  I deleted everything and rebuilt it so that AI is still in Central but everything else is in East US 2.  Things seem to be working fine now and updating as expected.  I can't say if the issue lied in the location or if there was a backend error somewhere that I don't have access to. 

[rsmccall33]

1. Update:  When viewing the blob storage in Azure preview portal, I can see folders for Availability/yyyy-mm-dd/hh and I can open the URL for the json and see that there is data in there.  However, when in Stream Analytics, I try to get a sample of data for the last 10 minutes it reports that there is no data.  How is that possible?  I have verified that the SA input has all of the correct settings and storage key.