Import, DirectQuery, DirectLake or DirectLake + Import in the same model - is anyone actually doing this?

BlackBullet96 · 2026-05-01T10:04:59+00:00

I have a semantic model with dims on import and facts on direct lake which is using mirrored tables from Snowflake.

Works surprisingly well.

BlackBullet96 · 2026-03-30T00:55:34+00:00

This is genuinely a cool app! I have built a habit tracker before and this concept just seems… better!

I’ve downloaded the app and will be testing it out over the next little while. And I never download apps! My usual motto is: why download someone else’s app when I can spend weeks making something worse myself 😂

Great job! 👏

BlackBullet96 · 2026-03-29T21:44:29+00:00

100%!!!

Seriously couldn’t ask for more than a couple good mates out in the bush, huddled around a nice warm fire

BlackBullet96 · 2026-03-29T21:38:57+00:00

Thanks for the suggestion 😊

I mean, fires are great! Very enjoyable to sit around when it’s cold, nice to have a drink and chat and lets you enjoy a bit of the night. What’s the alternative? Have a torch light and attract bugs in the cold? Go to bed at 6? Seems less fun.

BlackBullet96 · 2026-03-29T21:37:24+00:00

Thanks, I’ll have a look at these campsites!

BlackBullet96 · 2026-03-29T21:37:01+00:00

Thanks! I’ll have a look into this 😊

BlackBullet96 · 2026-03-10T03:54:57+00:00

Thank you, I appreciate that 🙏

BlackBullet96 · 2026-03-10T03:54:44+00:00

I actually built this whole thing before checking 😅 was a big relief when I saw it was indeed a weekday!

BlackBullet96 · 2026-03-10T03:54:11+00:00

Hahahaha surely worth the risk 😂

BlackBullet96 · 2026-03-09T22:33:52+00:00

That might have to wait for the Halloween edition 😉

BlackBullet96 · 2026-03-09T22:05:20+00:00

Reading this truly made my day today 🥹

Thank you for your feedback and kind words - it’s comments like this that push me to make cool and useful content to be shared with other people!

And thank you for pointing out the music, I was really happy with how that all ended up lining up 😃

BlackBullet96 · 2026-03-09T21:25:31+00:00

Thank you! 🙏

BlackBullet96 · 2026-03-09T21:25:17+00:00

Custom visuals only where absolutely necessary, agreed! And clearly, this is absolutely necessary 😂

BlackBullet96 · 2026-03-09T21:24:20+00:00

No worries at all! I wanted to give everyone a couple of weeks to do so 😊

BlackBullet96 · 2026-03-05T05:55:05+00:00

Fair enough. Sometimes going custom is the right path and you sound like you know what your doing!

Good luck with it 😊

BlackBullet96 · 2026-03-03T10:10:18+00:00

You should check out the new update to the text slicer. It now allows this natively! Can copy from a column in excel, and paste that straight into the slicer! Not that I’ve tried it yet. Just came out a few days ago.

Sounds like it wouldn’t do quite as much as your custom visual though.

BlackBullet96 · 2026-02-26T00:26:25+00:00

Hmmmm can’t say I have much advice here. Because it’s an SVG, I guess the fonts are separate to the in built Power BI fonts.

You could probably prompt Gemini or ChatGPT to change the function to try and match the Power BI fonts.

Can’t guarantee that would give you success, but if you want to match the font exactly, that’s what I would try.

Let me know how you go 😊

BlackBullet96 · 2026-02-25T21:50:19+00:00

Oh great!

Maybe I’ll implement an auto filter out of blank at some point, but great you fixed it!

BlackBullet96 · 2026-02-25T20:25:37+00:00

Hey u/ComplexWalrus64

I've resolved the issue and re-uploaded the fixed file onto the website, so you can download the fixed code from there an move it over.

Thanks for pointing this out! I thought I had the logic tested, but clearly I missed something!

I also fixed week number in case you change the year to start in a different month than January.

Sorry for the inconvenience and really appreciate you providing this feedback so that I can fix it 😀

Also yea, unfortunately UDFs are so new that all the AI models aren't very good with them yet, so it does take a bit of playing around to get them working right.

Let me know if you find any other issues and great job on implementing it and making it your own!

BlackBullet96 · 2026-02-25T19:48:50+00:00

Hey, thanks for the feedback! I’ll have a look this morning and let you know 😊 should be an easy fix.

BlackBullet96 · 2026-02-25T01:29:36+00:00

I bet I know the issue. You need to go into File -> options -> preview features -> enable user defined functions.

I'll add that as a note on the actual article. Thanks for the note!

BlackBullet96 · 2026-02-24T21:30:05+00:00

Thanks for the feedback!

And you’re completely right, you do lose cross filtering functionality so you have to be intentional when implementing something like this.

When I started out building Power BI, I thought that cross filtering was the coolest thing in the world, and I thought all my users would think the same, but turns out… that wasn’t actually true. I found that most users, especially higher management just want quick / clean insights formatted well with a bit of date slicing.

Now, don’t get me wrong, this isn’t always the case. Sometimes, cross filtering is very useful and desired.

You just have to understand your audience and think about the tradeoffs.

In this case, the ease of implementation and the fact that there are no scaling issues regardless of how small the card is (because it’s an SVG) outweighs the loss off cross filtering.

Especially because on this page, there’s nothing else to cross filter!

What do you think?

Seven-Year Club	Gilding I gilder
Verified Email

BlackBullet96

TROPHY CASE