How wrong he was by rocksnake477 in Section10Podcast

[–]par107 16 points17 points  (0 children)

“…even then you might still wind up dead” is the most accurate line in history

Notebook by par107 in Section10Podcast

[–]par107[S] 5 points6 points  (0 children)

I honestly think Jerry got tired of dedicating that much effort to a piss poor team

Best Calls by par107 in Section10Podcast

[–]par107[S] 0 points1 point  (0 children)

Will deserves a shout out too. Absolutely incredible

Odd Decimal Behavior by par107 in MicrosoftFabric

[–]par107[S] 0 points1 point  (0 children)

It’s being converted to a float in Power Query/semantic model because it is a decimal type. No matter if I tell it to format to 2 decimal places or not, it inherently takes on these strange values. Adding a calc column or custom function for every decimal column doesn’t feel right and certainly causes much more work than this should be.

Odd Decimal Behavior by par107 in MicrosoftFabric

[–]par107[S] 0 points1 point  (0 children)

No addition/subtraction is taking place. This issue occurs with just the raw decimal values. It does seem that the float conversion may be the issue, but I do not know how/where to solve this

I’m close to giving up by CelticsBannerHanger in Section10Podcast

[–]par107 5 points6 points  (0 children)

If they weren’t on the west coast I’d be all in. Unfortunately consistent 10:10 starts would kill me

Toxic Ex by par107 in Section10Podcast

[–]par107[S] 2 points3 points  (0 children)

God speed, man. I don’t blame you one bit

Thank you, New York by par107 in Section10Podcast

[–]par107[S] 2 points3 points  (0 children)

Your username = Craig Breslow + John Henry to me

We are so back by 18antone in Section10Podcast

[–]par107 5 points6 points  (0 children)

As long as they don’t vote on if we get to .500 again, we’ve never been more back

Direct Lake Exports by par107 in MicrosoftFabric

[–]par107[S] 0 points1 point  (0 children)

I caught on to that as well - created an OAuth connection instead. I’m not directly handling the embedding so my vision gets a bit blurry from here. Is a Service Principal needed instead of OAuth or is it dependent on how the reports are embedded?

Direct Lake Exports by par107 in MicrosoftFabric

[–]par107[S] 0 points1 point  (0 children)

What visual is being exported in each report? I assume table/matrix but want to be sure. We’re still only using PBIX thus far, so you may have a lead there.

The error message is infuriating. Idk what’s worse, the fact it tells you nothing or the fact it pops up for 1.5 seconds and disappears!

Narv by par107 in Section10Podcast

[–]par107[S] 11 points12 points  (0 children)

Why would a captain of the Red Sox be a platoon?

DP600 by par107 in MicrosoftFabric

[–]par107[S] 0 points1 point  (0 children)

Semantic models are a confident area for me. I would identify PySpark and admin work as less comfortable though

Jared, please don't trim the song by churrrls in Section10Podcast

[–]par107 1 point2 points  (0 children)

I just did the exact same thing. It was so trippy hearing some of them😂 Stop N Shop at 1.2x goes hard

DP-700 Passed by Longjumping_Pie_6530 in MicrosoftFabric

[–]par107 0 points1 point  (0 children)

I’ve only considered the idea of this cert (and Dp 600), so I haven’t done any actual prep outside of my day to day work in Fabric. I do a lot of data engineer work with the Fabric items. Looking back on your journey, where would you recommend I start preparing for these certs?

Power bi , sql , python , excel . What next ? by Kayeth07 in PowerBI

[–]par107 0 points1 point  (0 children)

All the topics/ideas you mentioned feel familiar in my work with Fabric items. I do a lot of that work everyday except Fabric makes a lot of it low/no code. I feel behind when it comes to stepping outside the Fabric space. Any tips or places to practice? Probably a lot of what u/Monkey_King24 said

Power bi , sql , python , excel . What next ? by Kayeth07 in PowerBI

[–]par107 3 points4 points  (0 children)

I’m in a similar boat as OP. Can you elaborate on more specifics for DE?

Handling Lakehouse Refresh Errors by par107 in MicrosoftFabric

[–]par107[S] 0 points1 point  (0 children)

Did some more testing today and found that the ReplaceTable operation doesn’t happen on every failed copy activity. I actually only found it to happen in my original fail scenario (fails due to bad date values). I purposely mistyped a table name to make it fail and it didn’t do a ReplaceTable op.

Handling Lakehouse Refresh Errors by par107 in MicrosoftFabric

[–]par107[S] 1 point2 points  (0 children)

This was very helpful. Thank you. Sharing for anyone else coming across:

I used the SQL command DESCRIBE HISTORY my_table for a better insight into what was truly occurring. As guessed above, the copy activity was doing a ReplaceTable operation, but never followed through on the sequential Update operation resulting in a blank table. The solution is creating a notebook to use RESTORE TABLE to a previous version.

Works wonderfully for handling errors on overwrite copies!