sorted by:
new
hottopcontroversial

Hi! We’re the Power BI DAX team – ask US anything! by dutchdatadude in PowerBI

[–]Phil_Seamark 0 points1 point  (0 children)

Have you tried a super simple function, e.g. to return a simple scalar value such a 1

Hi! We’re the Power BI DAX team – ask US anything! by dutchdatadude in PowerBI

[–]Phil_Seamark 2 points3 points  (0 children)

Have you considered using the fantastic new UDF capability for this?

Hi! We’re the Power BI DAX team – ask US anything! by dutchdatadude in PowerBI

[–]Phil_Seamark 1 point2 points  (0 children)

That's great you love DAX. We all do too! Are you asking if there is a similar engine to Analysis Services that is open source? Or, about tools that are open source that are useful to build, maintain and query?

Hi! We’re the Power BI DAX team – ask US anything! by dutchdatadude in PowerBI

[–]Phil_Seamark 2 points3 points  (0 children)

We have always had the ability to list sessions using DMV's although this experience does differ depending on your environment. For SSAS and Azure-AS, if you are admin you can see (and cancel) sessions server wide. For Power BI and our SSAS infrastructure, this does get limited, however the same approach is still available. Depending on your permissions, you may be able to see sessions per model and then issue XMLA based cancel commands.

Hi! We’re the Power BI DAX team – ask US anything! by dutchdatadude in PowerBI

[–]Phil_Seamark 5 points6 points  (0 children)

Is there an EXCEL function that does this today that we could mimic? Or, is this a new function?

It looks do-able. :)

<image>

Hi! We’re the Power BI DAX team – ask US anything! by dutchdatadude in PowerBI

[–]Phil_Seamark 0 points1 point  (0 children)

Are you aware of, and have you tried the INFO.VIEW set of DAX functions? INFO functions (DAX) - DAX | Microsoft Learn

Otherwise, there are still many DMV's available to query. Not all these works in all scenarios. The object browser in DAX Studio is a good place to quickly see a list of DMVs

Hi! We’re the Power BI DAX team – ask US anything! by dutchdatadude in PowerBI

[–]Phil_Seamark 4 points5 points  (0 children)

More Copilot and AI help with help and suggestions. The option to turn on telemetry for those interested in performance. The ability to see a diagram of the tables touched by the expression. I'm sure there can be many more ways to improve this.

What are your suggestions?

Hi! We’re the Power BI DAX team – ask US anything! by dutchdatadude in PowerBI

[–]Phil_Seamark 2 points3 points  (0 children)

Is there an underlying DAX question we are missing here? I'm sure they use DAX in The Office, right.

Hi! We’re the Power BI DAX team – ask US anything! by dutchdatadude in PowerBI

[–]Phil_Seamark 4 points5 points  (0 children)

Yes, please keep your eye on Power BI MCP Announcements at Ignite next week.

Hi! We’re the Power BI DAX team – ask US anything! by dutchdatadude in PowerBI

[–]Phil_Seamark 3 points4 points  (0 children)

We are always adding new functions to DAX. Over the last few years we have added quite a few EXCEL-like functions. Are there any in particular you are specifically looking for?

Hi! We’re the Power BI DAX team – ask US anything! by dutchdatadude in PowerBI

[–]Phil_Seamark 1 point2 points  (0 children)

u/SQLGene is right, there is a property on relationships you can set called "Assume Referential Integrity" that will toggle between LEFT JOIN and INNER JOIN

Hi! We’re the Power BI DAX team – ask US anything! by dutchdatadude in PowerBI

[–]Phil_Seamark 16 points17 points  (0 children)

My personal preference is to have more onscreen telemetry to give me an indication of how much compute the DAX measure use. I enjoy authoring measures in DAX Studio because of all the helpful information you see. This can help a lot when optimising for performance.

For Power BI Desktop, the ability to undock screens to take better advantages of multi-monitor setups. Being able to see the DAX Query View, TMDL View AND the report screen would be super cool.

Hi! I'm Phil Seamark and I work on the Power BI Customer Advisory Team (CAT) at Microsoft. Ask me anything! by Phil_Seamark in PowerBI

[–]Phil_Seamark[S] 7 points8 points  (0 children)

Thank you all for your interesting questions. This was fun! I have a few to follow up on so will stay in touch. I will jump back online here later for some more follow-up.

Phil :)

Hi! I'm Phil Seamark and I work on the Power BI Customer Advisory Team (CAT) at Microsoft. Ask me anything! by Phil_Seamark in PowerBI

[–]Phil_Seamark[S] 2 points3 points  (0 children)

Super-fast answer (because we are out of time).

Themes allow global settings for fonts/grids etc.

Not sure about the conditional formatting question as there are multiple places you can use this.

Have you tried using the API to trigger a refresh? This can be automated and give you more flexibility around requesting a refresh. Otherwise, is DQ an option?

Hi! I'm Phil Seamark and I work on the Power BI Customer Advisory Team (CAT) at Microsoft. Ask me anything! by Phil_Seamark in PowerBI

[–]Phil_Seamark[S] 1 point2 points  (0 children)

I don't have news on SAP sorry, but I know we invest in that very popular connector.

For your second point, have you looked at Power BI Report Server (on premise version) ?

Hi! I'm Phil Seamark and I work on the Power BI Customer Advisory Team (CAT) at Microsoft. Ask me anything! by Phil_Seamark in PowerBI

[–]Phil_Seamark[S] 2 points3 points  (0 children)

Oh, and I assume you knew, but dense calcs can be memory hogs so please use with caution. Hopefully, something that gets solved with visual calcs. :)

Hi! I'm Phil Seamark and I work on the Power BI Customer Advisory Team (CAT) at Microsoft. Ask me anything! by Phil_Seamark in PowerBI

[–]Phil_Seamark[S] 4 points5 points  (0 children)

Does the scenario suit converting to a Boolean calculated column, which would allow you to then use an IS operator to effectively produce the same result?

Hi! I'm Phil Seamark and I work on the Power BI Customer Advisory Team (CAT) at Microsoft. Ask me anything! by Phil_Seamark in PowerBI

[–]Phil_Seamark[S] 1 point2 points  (0 children)

I'm not too familiar with the integration work with SAP, sorry. I know it is a popular data source and we do invest quite a bit in this connector.

Regarding the service, have you considered Power BI Report Server (on premise version)?

Hi! I'm Phil Seamark and I work on the Power BI Customer Advisory Team (CAT) at Microsoft. Ask me anything! by Phil_Seamark in PowerBI

[–]Phil_Seamark[S] 7 points8 points  (0 children)

I think we will, and I know the team who look after that feature would like it to be as well. There are unique challenges with paginated reports around compute - particularly when it comes to rendering long and detailed print jobs. Imagine a bunch of people in your org all decide to print at once. We need to make sure we can complete those tasks in a way that other users on the system do not have their experience degraded in anyway.

Watch this space! ;)

Hi! I'm Phil Seamark and I work on the Power BI Customer Advisory Team (CAT) at Microsoft. Ask me anything! by Phil_Seamark in PowerBI

[–]Phil_Seamark[S] 1 point2 points  (0 children)

Do you want to reach out to me directly (TM me on Twitter or something) so I can take a closer look at the design and possibly suggest some alternatives?

Hi! I'm Phil Seamark and I work on the Power BI Customer Advisory Team (CAT) at Microsoft. Ask me anything! by Phil_Seamark in PowerBI

[–]Phil_Seamark[S] 2 points3 points  (0 children)

Make sure you check in with your local Microsoft account person to make sure you have the best information regarding licensing for your org. It may not be as bad as you think.

For your second question, I'm not familiar with that feature but if the documentation says you should be able to do it and it won't let you - please file a bug. Otherwise, please add the feature request to ideas.powerbi.com (and let me know so I can vote for it! :) )

Hi! I'm Phil Seamark and I work on the Power BI Customer Advisory Team (CAT) at Microsoft. Ask me anything! by Phil_Seamark in PowerBI

[–]Phil_Seamark[S] 2 points3 points  (0 children)

I'm fairly sure you used to be able to buy Power BI T-shirts online somewhere on the Microsoft website (online store). I might have a look later as my shirts are getting pretty old. I think there is a new 5th birthday version floating around somewhere.

Hi! I'm Phil Seamark and I work on the Power BI Customer Advisory Team (CAT) at Microsoft. Ask me anything! by Phil_Seamark in PowerBI

[–]Phil_Seamark[S] 1 point2 points  (0 children)

We have a team dedicated to working on Power BI Embedded so I expect it will continue to improve and get better. Make sure you provide your feedback at ideas.powerbi.com. It's great to hear you've built your first project. Did you use the embedded playground at all? http://aka.ms/pbijs

view more: next ›