cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sandayuu New Member
New Member

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 2
philipplenz Established Member
Established Member

Re: Stream Analysis refresh problem with "the data set doesn't contain any data model connectio

Do you have a solution for this problem?

philipplenz Established Member
Established Member

Re: Stream Analysis refresh problem with "the data set doesn't contain any data model connectio

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 ... 

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)