topic Re: Using DAX with live data in Developer

Using DAX with live data

Weatherreport — Wed, 14 Apr 2021 02:35:46 GMT

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

Re: Using DAX with live data

MawashiKid2 — Wed, 14 Apr 2021 03:36:30 GMT

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

Re: Using DAX with live data

Weatherreport — Wed, 14 Apr 2021 04:47:32 GMT

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

Re: Using DAX with live data

MawashiKid2 — Wed, 14 Apr 2021 12:52:07 GMT

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

Re: Using DAX with live data

V-lianl-msft — Fri, 16 Apr 2021 02:44:42 GMT

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.

Re: Using DAX with live data

Weatherreport — Mon, 19 Apr 2021 01:49:54 GMT

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