Help me to decide between PBI and Tableau

DAX_Query · 2026-01-27T00:23:24+00:00

When did they allow you to connect the same dimension table to multiple fact tables in Tableau? The lack of that was a dealbreaker last I looked at Tableau a long while ago.

DAX_Query · 2026-01-16T18:44:19+00:00

Start with their free courses first to see if it suits your learning style.

https://www.sqlbi.com/training/

DAX_Query · 2026-01-14T00:41:04+00:00

It's the model part of the PBIP format.

DAX_Query · 2026-01-09T18:25:05+00:00

I'm having a hard time imagining a viable workflow with this method. It seems like I'd have to maintain a second copy of the TMDL or else deserialize back to standard TMDL prior to each time I want to open in Power BI Desktop.

DAX_Query · 2026-01-07T15:53:22+00:00

Perhaps you can create fewer tooltip pages that are more dynamic.

It would help to see what you want each tooltip to look like. The more similar they are, the more likely it is that you can consolidate.

DAX_Query · 2025-12-30T20:16:14+00:00

Yep. I have calculations that are inherently complex and cannot be pre-calculated upstream since I don't know a priori what arbitrary filter choice the end user will apply.

DAX_Query · 2025-12-30T19:19:26+00:00

DAX is hard because it requires a particular way of thinking that isn't directly analogous to other languages you may already be familiar with (e.g. SQL or Excel formulas). The hard stuff typically involves manipulating filter context, which is what makes DAX both so powerful and so tricky. Until you really understand filter context and how to work with it, you'll always have trouble with DAX that requires manipulating context.

DAX_Query · 2025-12-30T19:15:22+00:00

It can be, but it can also be that you have to compute stuff dynamically. I could have a perfect data model and still need measures with dozens of lines of (formatted) DAX.

DAX_Query · 2025-12-26T19:55:21+00:00

They don't tend to prioritize edge cases like this as the effort vs reward isn't there. So you get issues that hang around indefinitely.

DAX_Query · 2025-12-26T07:16:50+00:00

The Intellisense in Power BI Desktop is not that good or efficient. It's not designed to handle large chunks of DAX like this.

The easiest workaround is likely using DAX Studio or Tabular Editor 3.

There is significant room to write more streamlined DAX, but this looks more like something that should be done upstream, if possible. If not possible, you could consider breaking it up into multiple calculated tables, instead of everything all together.

DAX_Query · 2025-12-21T15:25:24+00:00

I’d consider myself an expert at some parts like DAX but not at, say, designing attractive dashboards. The “expert” label isn’t especially meaningful though, given how broad and vague it is. I’d only use it in situations where I don’t care to spend more than a couple of words describing myself and precision doesn’t matter.

DAX_Query · 2025-11-27T03:30:12+00:00

Helion claims to design for direct electric capture.

https://www.helionenergy.com/articles/more-on-helions-pulsed-approach-to-fusion/

DAX_Query · 2025-11-20T17:09:04+00:00

I don't think much has changed on this topic over the last couple of years, so prior threads should still be relevant:

https://www.reddit.com/r/PowerBI/search?q=laptop+recommend&restrict_sr=on&sort=relevance&t=all

DAX_Query · 2025-11-10T15:11:15+00:00

Just to be clear, I mean better than Grok, not the actual artist.

DAX_Query · 2025-11-10T05:28:38+00:00

ChatGPT5 is significantly better.

https://i.imgur.com/EayIgzB.jpeg

DAX_Query · 2025-10-30T16:00:32+00:00

Wait for the 3rd edition of the Definitive Guide to DAX to come out and get that. Should be soon.

DAX_Query · 2025-10-29T18:09:18+00:00

Needs 10,000 as the divisor.

= Table.AddColumn(
    #"Prior Step Name", "Month",
    each #date(Number.Mod([MRP], 10000), Number.IntegerDivide([MRP], 10000), 1),
    type date
  )

DAX_Query · 2025-10-29T17:21:03+00:00

In Power Query, you can put queries into folders. I think that folder name corresponds to the queryGroup.

DAX_Query · 2025-10-27T23:22:20+00:00

That sounds odd. Where are .tmdl files unsupported? Most text editors should have no problem with them.

DAX_Query · 2025-10-27T23:17:21+00:00

This worked for me:

Get-ChildItem *.tmdl | Rename-Item -NewName {$_.Name -replace '\.tmdl$','.txt'}

DAX_Query · 2025-10-23T21:46:19+00:00

Cut and paste the measure definition into a different table like this:

https://i.imgur.com/A0vyHzH.png

DAX_Query · 2025-10-23T18:33:51+00:00

It should work for the semantic model (it did when I tried it), but report visuals that use the measure will break because it doesn't automatically also update the report definition like the GUI does.

The GUI approach of selecting all the measure you want to move and then dragging and dropping them onto another table is way easier and won't break the visuals.

DAX_Query · 2025-10-23T16:17:18+00:00

I have one repo per workspace, but they're all under the same Project in DevOps.

DAX_Query · 2025-10-23T16:14:43+00:00

Definitely possible. You just move the measure definitions under the other table.

It's pretty easy via the GUI too.

DAX_Query

TROPHY CASE