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

Using DAX with live data

Hi Everyone,

 

My business would need to display live sales data (eg. refreshing every 30 seconds). My understanding is that:

 

1. PowerBI pro allows 8 refreshes (so no live data)

2. PowerBI Premium per user allows 48 refreshes (so definitely better but no live data yet)

3. DIrect Queries allows live data but then we cannot use more complex time intelligence DAX expressions

 

So my question is:

Is there any way to show live data whilst also being able to use complex DAX expressions?Anything to do with Azure maybe?live datasets?Live connections?or what else?

 

Thanks,

Marco

1 ACCEPTED SOLUTION
V-lianl-msft
Community Support
Community Support

To prevent you from accidentally building calculations that will perform badly in DirectQuery mode Power BI tries to prevent you from using any DAX functions that it thinks it can’t generate efficient SQL for.

View solution in original post

5 REPLIES 5
V-lianl-msft
Community Support
Community Support

To prevent you from accidentally building calculations that will perform badly in DirectQuery mode Power BI tries to prevent you from using any DAX functions that it thinks it can’t generate efficient SQL for.

View solution in original post

Thanks @V-lianl-msft 

I think that DirectQueries is a reasonable solution for real time data but yes (if I get your point) it is probably better to sort out more complex things at SQL level rather than at a DAX level

MawashiKid2
Frequent Visitor

RE: Install a satnav in a new car but having to lose two tyres to do that!

 

LOL That's a good one...BTW I never mentioned this was THE golden solution. I only referred it as an example. Solutions don't always come served on a silver plate. It would be a bit naive to think that. That's the name of the game. If someone has a better solution then be my guest... I'll be more than glad to hear about it To be honest I'm no longer in ego sprints for kudos...😉 

MawashiKid2
Frequent Visitor

Perhaps you may have a look at following link provided by Radacad:

Writing calculations on a real time streaming Power BI dataset using DAX measures 

Thanks for your reply @MawashiKid2

I had a look into that article but it doesn't sound that convincing to me. It is like it is showing how to install a satnav in a new car but having to lose two tyres to do that! 🙂

 

However, happy to hear different opinions from someone that has used the streaming datasets for complex time intelligence DAX expressions

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!

Top Kudoed Authors