Stream Analysis refresh problem with "the data set doesn't contain any data model connections" error

[sandayuu]

Hi guys,

I have a problem with PowerBI Pro and Stream Analytics integration. 

I want to automatically refresh the dashboarad, however, it dosen't work.

I noticed that the data set shows this message.

Settings > Datasets > myDataSet

"Refresh can't be scheduled because the data set doesn't contain any data model connections, or is a worksheet or liked table.

 To schedule refresh, the data must be loaded into the data model."

Could you give me some adivice, please?

I tried to analyize realtime twitter stream. I'm writing some additional information.

Twitter ->  EventHub -> Stream Analytics -> PowerBI Pro

The report is pined on Dashboard. when I refresh it manually, the graph is updated.

This is the query of Stream Analytics

SELECT
    System.Timestamp as Time, Topic, COUNT(*), AVG(SentimentScore), MIN(SentimentScore),Max(SentimentScore), STDEV(SentimentScore) 
INTO
    TwitterAnalysisOutput  
FROM
    TwitterAnalize TIMESTAMP BY CreatedAt GROUP BY TUMBLINGWINDOW(s, 5), Topic

Regards,

sandayuu

[Anonymous]

Do you have a solution for this problem?

[Anonymous]

I've got it with help from here: 

http://stackoverflow.com/questions/37353925/powerbi-and-stream-analytics-auto-refresh-doesnt-work/37...

You must use the Q&A function and pin it on you're dashboard, then the refresh function will work ...