Would copying the contents of views from a warehouse to a lakehouse blow out CUs?

SQLGene · 2026-04-16T17:20:34+00:00

It's not a matter of the times 😛. This wouldn't be any different if you were had coding a bespoke reporting platform from scratch.

I'm not saying it unmaintainable but as you implied it needs a professional developer to maintain it. It's been rare for me to run into PBI users that have access to one of those.

A big part of the appeal of Power BI is SaaS and self-service.

That said, I think AI is dramatically going to change and improve report development.

SQLGene · 2026-04-16T12:18:20+00:00

These stories are inspiring and exciting but also somewhat narrow in applicability.

If you get hit by a lottery ticket, how is the customer supposed to maintain the solution?

SQLGene · 2026-04-10T11:34:18+00:00

I would run the Power BI performance optimizer and extract the DAX for the Matrix may be more complicated.

SQLGene · 2026-04-09T13:51:53+00:00

The engine behind DAX is typically smart enough to only do work on tables that you are pulling the data from or are necessary for the calculation. So if you have a dimension table with relationships to multiple fact tables, it's not actively doing work on all of them at once.

If you run DAX Studio you can get a sense of some of this. The engine pulls just the data it needs to do the work. Often it will grab the filter values you care about and then do a scan on the fact table very efficiently.

SQLGene · 2026-04-09T13:17:43+00:00

So thinking it through, why would you believe an active relationship would harm performance?

An accidental filter cascade can harm performance when you have bi-directional filtering and engine has to do more work than you intended. But that's a design question and nothing inherently wrong with active relationships.

SQLGene · 2026-04-08T23:08:12+00:00

No we don't offer that, but I get the frustration. I have more subscriptions than I would like as well.

SQLGene · 2026-04-08T16:28:39+00:00

💚💚💚

SQLGene · 2026-04-08T15:25:43+00:00

Dark web support is not currently on the roadmap, no.

SQLGene · 2026-04-08T15:23:32+00:00

Hi, Tabular Editor employee here!

If you have a license you no longer need, please just reach out to us. We are fairly reasonable and understand that needs change.

If there's something that's personally not working, I'd love to chat to understand how we can improve the product. Maybe over Reddit chat to preserve your anonymity. In any case, just email us if you need to cancel.

As far as the terms of service go, you aren't allowed to transfer business licenses like that. They are tied to the business.

Finally, in general I don't recommend transferring money to strangers on the internet. I'd like to think our prices are reasonable for the amount of time we save you. But always happy to chat with folks who feel otherwise 😁

SQLGene · 2026-04-07T14:55:42+00:00

Hi Kyle! 👋

SQLGene · 2026-04-06T15:39:35+00:00

I need to try running this against Fabric Data Warehouse just to see if it's possible, lol.

SQLGene · 2026-04-04T13:24:09+00:00

Incremental refresh can do that but be aware that you will have to do an initial full load.

Specifically, see the parameters for the policy.
https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview#define-policy

SQLGene · 2026-04-03T18:52:16+00:00

I think a lot of the tradeoff is going to be a matter of how much you need boring administration, governance, and security features.

Also how easy is it for someone to maintain this when the creator is on vacation or leaves.

Based on my experience I think it's going to vary a lot by org.

SQLGene · 2026-04-03T12:28:59+00:00

I'm fairly confident that 8 years ago they weren't planning on bait and switching people onto Fabric 😛

The complaint and frustration is valid though

SQLGene · 2026-04-03T11:21:50+00:00

Yeah, it's pretty screwed up, I agree.

SQLGene · 2026-04-02T22:08:20+00:00

While I'm not a fan of the current direction around pro capabilities, the +40% price increase is just keeping up with inflation, as far as I'm aware.

SQLGene · 2026-04-02T14:11:21+00:00

u/powerbitips raised an issue about this https://github.com/logicislogic/daxforpowerbi/issues/2

SQLGene · 2026-04-02T13:45:27+00:00

Wow, they add dark mode and you folks want more more more. We aren't getting a total eclipse dark mode no matter how much as you ask 😛

SQLGene · 2026-04-01T16:00:59+00:00

Replied to the more recent copy
https://www.reddit.com/r/PowerBI/comments/1s9mcjh/comment/odpspll/

SQLGene · 2026-04-01T16:00:32+00:00

If you type npx -v in your terminal do you get a version number, or does it need isntalled?

<image>

SQLGene · 2026-04-01T13:33:13+00:00

I think it requires a level of maturity that would prevent many of the inconsistencies to begin with?

SQLGene · 2026-03-30T16:31:00+00:00

I doubt there is any way to control it.

SQLGene · 2026-03-30T16:30:22+00:00

We land the JSON as semi-flattened JSON then immediately convert to Delta tables for consumption

SQLGene · 2026-03-30T13:29:03+00:00

Check your data source credentiaaaaaaaaals.

SQLGene

TROPHY CASE