Forum Discussion
Stream Analysis refresh problem with "the data set doesn't contain any data model connections" error
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
2 Replies
- AnonymousNot applicable
Do you have a solution for this problem?
- AnonymousNot applicable
I've got it with help from here:
You must use the Q&A function and pin it on you're dashboard, then the refresh function will work ...