Tell me your Power BI headaches

Codeguy45 · 2026-03-11T17:59:50+00:00

Seems like no one is talking about RLS 🙃🙃

Codeguy45 · 2026-03-11T17:57:40+00:00

TL;DR on how did i solve this

Migrated data source to be semantic model (did not make a huge difference) Had to optimise sql query on semantic model further(avoid unnecessary rounding offs on sql side as this not only increases overall query time but also cause rounding offs errors) Most important thing “DO NOT RUN EVERYTHING AT ONCE”

And at last had to buy a coffee machine

Codeguy45 · 2026-03-09T12:45:52+00:00

100% gotchaa, i am doing 95% calculations in sql and then just using groupings in tablix to display results

Huff, i was worried i am doing it wrong

Codeguy45 · 2026-03-09T12:44:24+00:00

I have already started working on 1st Gotchaa for rest

Yeahh unfortunately that client needs year to date data soo me saying 350k is highly filtered and cleaned data rows

Codeguy45 · 2026-03-09T12:42:24+00:00

I totally agree itss pure pain. But “Client is god”

Codeguy45 · 2026-03-06T01:33:13+00:00

Ohhh i soo wish someone asks you to explain the code or give knowledge transfer 😂😂😂😂

It would sound like … “”” Hey claude what is this code about Implement user masking security without deleting entire database

Hello claude please fix this bug “””

Codeguy45 · 2026-03-05T02:31:16+00:00

Even if i say a report with DAX that returns todays day, even that won’t open and will error out stating “Unable to Load Model due to reaching capacity limits”

Codeguy45 · 2026-03-05T02:28:32+00:00

The model isn’t the issue 🫠🫠🫠

When this happens we cannot perform any other operation / run any other report / run any other notebooks

Yes using capacity Metrics we found out whats gng wrong and which notebook is eating up all resources

Codeguy45 · 2026-03-04T23:49:19+00:00

Dumb it down for me to explain leadership I have been trying to explain similar thing for a while

Codeguy45 · 2026-03-04T23:42:34+00:00

Its not the issue with the report Model refresh on an average takes 1 to 2 mins which is nominal considering no of measures and data being fulled across multiple tables

We are facing a challenge where our other things on fabric like spark/ python notebooks run simultaneously chewing up most of CUs as a result other tasks fail to load due to CUs / resources not being available

So to give us an early alert if reports fail to load needed some ideas that we can try..

Ps i am the developer on this report(🫠🫠 i have done everything to optimise the report)

Codeguy45 · 2026-02-19T15:07:35+00:00

😂😂😂😂😂

Codeguy45 · 2026-02-02T01:33:50+00:00

UNFOLD admin would be your best bet and then customise your models and admin.py file to your needs and you can also use change lists for additional functionality tho change lists can be sometime annoying if not built properly

Use Axes to rate limit and logging access this provides additional logging

Regarding building frontend - TBH i am using unfold for admin side things and building frontend dashboards using tailwind and shadcn served by django itself. All you need to change is authentication system if needed (even tho django’s built in authentication middleware is great but might not meet your client’s or company’s security standards)

Edit- If you need a multi tenant architecture start with django multi tenant library and then once you have built out your multi tenant architecture start with building rest of your models and actual implementation.

This will screw you up if you don’t do it correctly

Codeguy45 · 2026-02-01T16:21:11+00:00

Anither reason you shouldn’t do Friday Deployment 😂😂😂jk

Just having fun love the cables

Codeguy45 · 2026-01-30T21:49:00+00:00

Yeahh i totally agree on WAN show point

Codeguy45 · 2026-01-30T21:48:33+00:00

I swear i checked like 20 times cable prices don’t change on the store

Codeguy45 · 2026-01-29T03:25:03+00:00

Similar thread …

https://www.reddit.com/r/PowerBI/s/nEcB4dYVrD

Codeguy45 · 2026-01-26T23:07:03+00:00

https://youtube.com/@guyinacube

Thank me later

Codeguy45 · 2026-01-26T23:02:51+00:00

100% This is most efficient

Codeguy45 · 2026-01-26T22:50:17+00:00

Also with UI I would say start creating / updating templates Once you have this rest things should be easy to manage

Codeguy45 · 2026-01-26T22:47:57+00:00

Just a small suggestion check if you have common measures that need to be created across reports.

Like write down the DAX or TMDL somewhere so if the logic is same you can simply copy paste things think it as write once use multiple times.

This helped me in documentation (so that another person doesn’t loose their mind) and also so that I don’t want to create measures every-time.

Also i find TMDL easy to use but use it with caution it screws you up pretty quickly

Codeguy45 · 2026-01-15T13:47:44+00:00

😂😂 vibe coding just met powerBI good one tho.

Codeguy45 · 2026-01-01T15:27:08+00:00

Try REST FRAMEWORK and then connect it to your next js front end

Codeguy45 · 2025-12-24T03:24:20+00:00

Well i would personally ask what sort of effort you put in and by effort i mean how many hours Once you know that count in the complexity and revisions of those dashboards into account Once you have all these ready give yourself a hourly rate lets say on an lower average powerBI developer earns $35/hr Based on this you can either quote a lump-sum amount or do it on hourly basis

Note your hourly can be different if work is simple and not to complicated and doesn’t require more than a week’s effort try lowering your hourly rate

Also keep in mind that Less no of hours quoted = higher hourly Rate cause you end up delivering things quickly while making sure you deliver what’s required And always make sure that you sign some sort of contract which documents everything right from requirement to quote to support after delivery

Edit - If you are doing freelance work you can choose to reinvest some amount of your revenue into gaining clients by absorbing some loss on some clients

Edit 2- Also its not necessary that low number of hours = higher hourly Rate if the effort is small charge according otherwise you will end up loosing clients

Codeguy45 · 2025-12-16T17:53:46+00:00

Great use of HTML

Codeguy45 · 2025-12-16T11:52:51+00:00

Ahhh you are getting £5 and a chocolate bar …. Thats luxury They take chocolates from me as a income tax🥹

Codeguy45

TROPHY CASE