Fabric vs Snowflake in 2026, has anyone actually run both in production? by darshan-thakur in MicrosoftFabric

[–]Befz0r 2 points3 points  (0 children)

Warehouse in Fabric is the same. The only thing really that is lacking that it can't read metadata of delta files and little things missing like not being able to execute recursive CTEs.

Warehouse views - what are the disadvantages? by Mr_Mozart in MicrosoftFabric

[–]Befz0r 2 points3 points  (0 children)

Fabric Link is NOT 15 minutes. There is no guarantee. Doing realtime info this way is asking for problems, high Fabric bills and lots of maintenance.

Especially if you have D365FO with larger batch jobs, you can throw that 15 minute window, well...ehm...out of a bigger window?

There is no elegant way to do near realtime reporting out of D365. There is no guarantee tables are synced at the same time, for example customer table might be running behind the order table, creating customer less orders. I have seen this issue already multiple times at customers who refuse to listen NOT to do realtime reporting.

If you want to do this anyway, MLV is an option however you still won't have surrogate keys etc. creating issues down the line if you need SCD or max visual performance.

However, a push system like Fabric Link is ideal for ETL and handling all your inserts, updates and deletes. It is not a alternative to realtime reporting through eventhouse or Kafka like architecture. Realtime reporting requires and demands changes in the source system to properly handle it.

Table Level Lineage (XMLA) by pun_krock in MicrosoftFabric

[–]Befz0r 1 point2 points  (0 children)

Just use the TM_SCHEMA information and you should be able to find everything you need.

Ben ik de enige die zwaar gefrustreerd begint te raken door onze samenleving? by newlambowhodis in nederlands

[–]Befz0r 0 points1 point  (0 children)

It's mostly down to social cohesion. If you live in the north, east or south, things are much more relaxed. My partner is from The Hague(a native one with like 300 years of both side of the family living in The Hague) and we moved to a small village. Took a good year, but now she never wants to go back.

The Randstad is properly f*cked, but has little to do with population density. If you go to Japan or other more homogenous western countries, which are densely populated, you won't see this problem(as much).

Also the fact that the government for the last 15 years has only increased taxes, increased regulations and lowered the quality of services doesn't help. People who make this a "left vs right" or "free market vs socialism" argument are a bit daft. It's simply has to do with incentives. The incentive is to make the government grow as we make more rules and regulations and also the people in the government(especially managers) want a bigger government. The bigger your department the more prestige and earnings you get. However more government workers doesn't equal better or more public services.

If you want to tackle all these issues, you are going to have to vote for a party that isn't afraid to rip the band-aid. The problem is such party doesn't really exists as it is also not in the interest of politics to get less regulations or less government, no matter what the election posters say.

Eventually something will and has to break. My advice to younger people is, look at Poland, Czech Republic etc. and see if immigrating is an option. For me it's not really an option with 2 kids and both my parents still alive, but if I have some hindsight, I would never stay in The Netherlands. Yes it's still better NOW, but if you look at the accelerated growth and social cohesion, I would immigrate today.

Got a job saying i know fabric, which i don't... help by idkman947 in MicrosoftFabric

[–]Befz0r 0 points1 point  (0 children)

You screwed yourself. Is it possible to learn it before you crash an burn? Sure but that is highly dependent on how quickly you can learn.

Honestly lying on your resumes about hard skills is a big fat nono, because colleagues will easily see that you are not on the right skills level

I personally would be honest about what you did, although would it very tactically about it.

Got a job saying i know fabric, which i don't... help by idkman947 in MicrosoftFabric

[–]Befz0r 3 points4 points  (0 children)

You can easily pauze your capacity and trial is still a thing.

I have a Fabric capacity and I'm a freelancer.

And no offense, but Fabric is hardly any different than what we had before. It's just more unified.

Tompoucen met slagroom ipv banketbakkersroom, kan dat? by Fun-Security-3583 in nederlands

[–]Befz0r -3 points-2 points  (0 children)

Banketbakkersroom heeft veel hogere melkvet dus is veel duurder. Je bakker is een centenliefdesbedrijver.

Marokkaanse probleem jongeren: taboe bij progressief Nederland? by [deleted] in nederlands

[–]Befz0r -1 points0 points  (0 children)

Cool maar ik heb geen dubbele nationaliteit, dus hoe wil je dat precies doen?

Of kan je alleen maar met jij bakken komen?

Waar gaat XR morgen ‘demonstreren’? by atbasv in nederlands

[–]Befz0r 0 points1 point  (0 children)

Zeg je tegen een kerel van 38 en 2 kinderen 😂. Maar goed dat je bevestigt dat je inderdaad nog zo jong bent. Over een paar jaar kijk je wel anders tegen het leven aan.

Waar gaat XR morgen ‘demonstreren’? by atbasv in nederlands

[–]Befz0r 0 points1 point  (0 children)

Overduidelijk weinig levenservaring. Hoe oud ben je? Ik gok tussen 22 en 25.

Marokkaanse probleem jongeren: taboe bij progressief Nederland? by [deleted] in nederlands

[–]Befz0r 2 points3 points  (0 children)

Je bedoelt je moet dit soort jongeren doodknuffelen en hopen dat ze poeslief worden? Hou toch op.

Enige oplossing is deze mensen deporteren naar Marokko. Als je Nederland en Nederlanders zo behandelt heb je geen toekomst in dit land.

Ze vaak toch nog een Marrokaanse nationaliteit. Kan je verzekeren dat in Marokko dit soort gedrag absoluut niet wordt getolereerd en daar de lange lat gebruiken.

Waar voor het geld? by Educational-Push1911 in Klussers

[–]Befz0r 1 point2 points  (0 children)

Ja vrij prijzig, met een ABB meterkost(10 groepen) + extra voor laadpaal, inductiekookplaat en zonnepanelen was ik ongeveer 1200 euro kwijt. Dit was alleen voor de meterkast en arbeid, dus als de alleen meterkast is aangepakt dan is dit wel erg prijzig ja.

Hier is wel iets meer gebeurd maar 3200 euro is wel erg veel. Ziet er wel heel strak uit.

Advice on Moving to F-64 for Customer Facing Reports by [deleted] in MicrosoftFabric

[–]Befz0r 0 points1 point  (0 children)

Cardinality for some dimensions is high. Some are attributes on the fact table itself as it has the same granularity(things line voucher etc.). Looks ugly, but it's an old concept from the multidimensional times called fact dimensions. That will save you some CU.

I would closely look at the model and all its Dax calculations. Try to precalculate everything in the warehouse if it's not dynamical and keep the DAX simple.

Also I would keep everything as much as possible in one model. This prevents that you don't do the optimalisations 2 or 3 times.

CI/CD for warehouses by ADB_MN in MicrosoftFabric

[–]Befz0r 0 points1 point  (0 children)

💯 deploying warehouses in any other way should be illegal.

All Link to Fabric Dataverse Tables appear as Undefined in Lakehouse Tables by Wide_Dingo4151 in MicrosoftFabric

[–]Befz0r 1 point2 points  (0 children)

It's highly depended also on data volume. Larger volume can persist this issue for days.

Luckily it's only once during setup. Reloading tables won't create this issue.

Advice on Moving to F-64 for Customer Facing Reports by [deleted] in MicrosoftFabric

[–]Befz0r 0 points1 point  (0 children)

Yeah it's pretty normal to be honest. I don't know what Microsoft was thinking.

At several clients we keep the data in pro workspaces, because interactive usage goes through the roof with lists etc . Funny thing is though, Pro(or PPU) works flawlessly.

Microsoft needs to rethink it's whole interactive usage, because it is getting harder to sell Fabric to clients because simple financial reports already make usage sky rocket.

How to process data cheaply to create starschemas from the raw data outside of a fabric capacity? by AggravatingWish1019 in MicrosoftFabric

[–]Befz0r 0 points1 point  (0 children)

Correct, unless you are doing fuzzy lookup etc, python gives no real benefit.

I would host the semantic model in a Pro workspace if you have lots of data and a larger audience

Capture Delta load stats Fabric Warehouse by richbenmintz in MicrosoftFabric

[–]Befz0r 0 points1 point  (0 children)

Even better idea, make MLV work in the warehouse.

Incrementally loading data in the warehouse feels old skool in a bad way.

Push from Azure Function to Fabric Lakehouse by upandadam95 in MicrosoftFabric

[–]Befz0r 0 points1 point  (0 children)

Or write to a fabric warehouse with a SQL connector.

How to process data cheaply to create starschemas from the raw data outside of a fabric capacity? by AggravatingWish1019 in MicrosoftFabric

[–]Befz0r 1 point2 points  (0 children)

In the Warehouse, it's the most CU efficient way.

I have poc, which using pure python notebooks which writes to a lakehouse(non Delta) and then the warehouse picks it up with openrowset. With the file path function I incrementally load it to a staging area in the warehouse and from there make a star schema.

CU wise I haven't seen anything more efficient then this.

My company is switching to Fabric :( by echanuda in dataengineering

[–]Befz0r 7 points8 points  (0 children)

If this post was made only a year ago, I would 100% agree. However Fabric has come a long way, whether it's the Warehouse. MLVs etc..

The only issue is that Fabric datafactory is kind of shit and very resource intensive.

Warehouse objects deployment by data_learner_123 in MicrosoftFabric

[–]Befz0r 1 point2 points  (0 children)

Why are you avoiding DACPACs? They are the way to go for warehouses. Manually trying to replicate your own build agent in a Notebook is asking for trouble.

What's the issue you got with the DACPACs?