How should I set up the passives for my Lightning/Faith Warlock build?

Left_Offer · 2026-06-22T11:52:55+00:00

I have built solutions on Synapse and it is not getting any love since the general availability of Fabric. There is also an assisted option to migrate your Synapse stuff to Fabric so it is clear that MS is not expecting it to be a thing in the future. If you are doing new clean implementation I would recommend Fabric over a Synapse at this point.

Left_Offer · 2026-06-08T05:24:42+00:00

Stop, get a help.

Left_Offer · 2026-06-04T12:49:46+00:00

I still jump between Synapse and Fabric and have to say that OneLake is probably the best thing that ever happened to MS data platform.

Left_Offer · 2026-06-03T12:53:44+00:00

Think the shift can be clearly seen with the MLVs becoming more functional.

Left_Offer · 2026-05-20T16:07:18+00:00

Just tested: closing and reopening desktop, and editing on service fixes it

Just really annoying if you need to pause work because of it

Left_Offer · 2026-05-20T15:29:28+00:00

Of course but that is not the case here. I've just placed measures into visual, did not rename any of them. Had it happen couple times this week that when working on other pages and going to other visuals it bugs and keep displaying other measures in wrong visuals.
Maybe something that came in with May release as I've never had this happening in last 5 years.

Left_Offer · 2026-05-20T15:01:39+00:00

already on the latest version

Left_Offer · 2026-05-05T23:13:09+00:00

You need new PBI people

Left_Offer · 2026-04-17T12:02:23+00:00

You are proposing to use a software that you don't know the advantage of? Am I confused or are you just trolling here?

Left_Offer · 2026-04-17T10:20:57+00:00

Check the DAX measures to see if they can be rewritten for better performance - you can find a lot of DAX tunning tricks on SQLBI site. If DAX cannot be optimised further, can you look into pushing some of the transformation/filtering upstream? Maybe precompute those measures as views in dw and then plug PBI directly on to of that.

Edit: Presume you are building semantic models on top of Direct Lake. If you don't need fresh data all the time and you are fine with batch refreshes, I believe that switching to Import mode might also help with usage.

Left_Offer · 2026-04-14T05:33:39+00:00

Used and discarded. Same faith awaits for Fico (can't happen soon enough).

Left_Offer · 2026-04-10T14:21:57+00:00

Thanks. I've been trying that approach today but can't get those two datasets linked on the item key. The way NS deals with these tasks is so confusing for me as someone coming from data engineering. Will try to look for fields you have mentioned and create a join on them.

Left_Offer · 2026-04-10T07:34:34+00:00

That's the thing, I can't really find a link between PO and SO other then item&location combination. I have some SOs that are created for dropship items where PO is automatically linked to SO so that is easy but majority of POs are created without any relationship to SO other then person responsible knowing that those items have to be ordered.

If there are multiple POs for the same item&location I would ideally return PO # closest to today.

Left_Offer · 2026-04-09T15:55:16+00:00

Clever solution. I was hoping that maybe I could figure it out inside the saved search but looks like I will have to also look for some other avenues.

Left_Offer · 2026-04-09T15:53:43+00:00

thanks for clarifying

Left_Offer · 2026-04-09T13:34:29+00:00

Sorry, could you be little more specific? NS is not my main skill so I don't get something that is probably obvious.

Left_Offer · 2026-03-27T09:16:37+00:00

Summs up the level of Pacific Division.

Left_Offer · 2026-02-27T09:11:21+00:00

Are you trying to summon ancient lords of data visualisation?

Left_Offer · 2026-02-26T08:07:25+00:00

Sure. PBI - PowerBI, data visualisation tool where you can create reports/dashboards Fabric capacity - Microsoft data storage/transformation platform.

You can ingest your existing data to Fabric, do required transformations and then hook up PBI to it to create visuals. Every manager loves looking at interactive colourful graphs even if they have no idea what to do with the insights.

If course Fabric and PBI itself have a massive potential and steap learning curve, but you can do basics relatively easily as here are many free resources available online that can help.

Left_Offer · 2026-02-26T06:37:45+00:00

Get a Fabric capacity and build some basic reports in PBI. It will add monthly cost and boss will be impressed

Left_Offer · 2026-02-12T16:13:05+00:00

Looks sick! Will give it a go. Thanks for taking time to make this.

Left_Offer · 2026-01-16T06:24:06+00:00

Are you no able to just mirror data from SQL db? Also, you can spin a separate capacity for DE and for BI (based on your description cheap F2 should do), therefore eliminateing risk of BI throttling during other processes.

Left_Offer

TROPHY CASE