cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
hector3315 Frequent Visitor
Frequent Visitor

Real time at power bi reports and bi structure

Hellow everyone.

 

I'm new here and we are thinking how to deploy our bi structure.

We have seen some videos where microsoft get data in a live way and we were wondering how to do that. We think our structure has to have something like this picture:

foto.png

 

 

Untill now, we were using the power bi inform to the sql server database directly that is something that is so wrong because when we use it in directquery it takes a lot of time and when we use import the machine ram turns out because it is a big amount of data. We did this because we thought that was the most directly way to do it but this doesn't work

 

So the question is. Could you tell me which is the best way to do this(if it is possible and the best way using SSAS)?

 

If I'm right we should conect as in the picture for example through SSAS but at the end how we get the real time? i mean can i make that my SSAS conects in live with my sqlserver without overcharge it ?

 

A lot of thanks to all the respones Smiley Happy

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-qiuyu-msft
Moderator

Re: Real time at power bi reports and bi structure

Hi @hector3315,

 

Actual real time dashboards is getting data from Microsoft Power BI REST API or Microsoft Stream Analytics. For more information, see:

Real-time dashboards

Real-time streaming in Power BI (Preview)

 

Regarding the DirectQuery or Live connection, as it's a direct connection between Power BI and the database, there is no need to schedule refresh. When we interact with the visualizations, updated data will display. See: Live connections and DirectQuery to on-premises data sources.

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
Moderator v-qiuyu-msft
Moderator

Re: Real time at power bi reports and bi structure

Hi @hector3315,

 

Actual real time dashboards is getting data from Microsoft Power BI REST API or Microsoft Stream Analytics. For more information, see:

Real-time dashboards

Real-time streaming in Power BI (Preview)

 

Regarding the DirectQuery or Live connection, as it's a direct connection between Power BI and the database, there is no need to schedule refresh. When we interact with the visualizations, updated data will display. See: Live connections and DirectQuery to on-premises data sources.

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors
Top Kudoed Authors