Azure Stream Analytics and Power BI DAX RRS feed

  • Question

  • We have setup Azure Stream Analytics so that it has an:

    1) Input: Azure Storage Blobs (alias named: blobinput)
    2) Output: PowerBI (alias named: powerbioutput)
    3) Query: SELECT * INTO powerbioutput FROM blobinput TIMESTAMP BY RequestDateTime
    4)Ran the Azure Stream Analytics job. This was able to write into Power BI and the Dataset and table got populated properly.

    To perform analysis of our data, we need to create a few derived tables and columns from the above dataset, however the following challenges arise:

    1) Unable to find where to define DAX queries from the PowerBI website for a given Dataset and Table.
    2) Unable to find a way to access Datasets created by Azure Stream Analytics from the PowerBI Desktop application.
    3) Is there a way to have multiple Azure Stream Analytics Job Outputs that write to the same Dataset but different Tables in PowerBI?

    Will appreciate an expedite response as we want to take this solution to production shortly.



    Friday, December 11, 2015 7:23 AM