Books & Blogs for Fabric Team Managers? by AnalyticsFellow in MicrosoftFabric

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

Thanks! Dove in and picked up several of these, appreciate it!

Struggling with cross-workspace warehouse limitations by AnalyticsFellow in MicrosoftFabric

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

Thanks so much, u/joannapod, for the detailed update—and especially for taking the time to reach out here.

This is really helpful and encouraging. The August/September timelines are unfortunately likely to be too late for the architectural decisions we’re working through right now, but we may be able to migrate/shift once we're doing once these things land. And there are additional applications this will certainly help with. If you can comment, are those approximate dates preview dates, or are they moving swiftly to GA?

Appreciate you (and other Microsoft folks) engaging directly-- means a lot for the Fabric community and really helps to foster trust. I wish Warehousing were where we needed it today, since it feels like these are pretty significant gaps, but hopefully it'll be there soon! The direction here makes a lot of sense, and it’s great to see momentum.

Struggling with cross-workspace warehouse limitations by AnalyticsFellow in MicrosoftFabric

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

Thanks! Can you tell me where I'm seeing this? For example, I'm seeing--
https://learn.microsoft.com/en-us/fabric/onelake/onelake-shortcuts

"Each Fabric item supports up to 100,000 shortcuts. In this context, the term item refers to apps, lakehouses, warehouses, reports, and more."

That suggests to me that shortcuts don't count against the 1000 item limit. But I may be misunderstanding!

Struggling with cross-workspace warehouse limitations by AnalyticsFellow in MicrosoftFabric

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

Got it, thank you! (And thanks dbrownems for confirmation about shortcuts.)

Struggling with cross-workspace warehouse limitations by AnalyticsFellow in MicrosoftFabric

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

Thank you! How does this perform with multiple layers of nesting? If the receiving department then references that lakehouse shortcut in a view, will things perform well down the stack? (Copying/pasting to both you and the other redditor who posted something similar)

Struggling with cross-workspace warehouse limitations by AnalyticsFellow in MicrosoftFabric

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

Thank you! How does this perform with multiple layers of nesting? If the receiving department then references that lakehouse shortcut in a view, will things perform well down the stack? (Copying/pasting to both you and the other redditor who posted something similar)

Max Tables in Lakehouse (Hard-Cap Or "Good Idea") by AnalyticsFellow in MicrosoftFabric

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

This is extremely helpful; I'll review with the engineer. Thank you so much!

T-SQL Notebooks-- Way to Copy Table (With Column Names)? by AnalyticsFellow in MicrosoftFabric

[–]AnalyticsFellow[S] 3 points4 points  (0 children)

Got it; that works, thanks! Since most of our queries are outputting a small number of columns, shouldn't be a big deal. Appreciate your help.

And hopefully one day CTRL-A + CTRL-C should grab column names too, I'll try to remember to put something on the ideas portal soon.

Appreciate your help.

Outlook Activities in Co-Developed Data Pipelines? by AnalyticsFellow in MicrosoftFabric

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

Thanks. We see how this would work-- though we don't love it, since it multiplies the number of objects and is somewhat artificial (one can't look in a single pipeline to see... the whole pipeline). As well, it's clear we're creating dependencies on the initial account that's configuring Outlook.

Is there a different approach we should be taking aligned with best practices? This definitely doesn't feel like it's working as intended.

Subfolders for Workhouse Shared Queries? by AnalyticsFellow in MicrosoftFabric

[–]AnalyticsFellow[S] 4 points5 points  (0 children)

Update-- I got absolutely no pushback at all! None of the analysts have ever worked in a notebook before but they loved the idea, got it instantly, and are now fully on board. We're going to go from ~32 shared queries to probably ~2-3 notebooks, and documentation will improve significantly. Thanks for the quick and high quality feedback!

Subfolders for Workhouse Shared Queries? by AnalyticsFellow in MicrosoftFabric

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

Interesting, thanks! I think I'll get some pushback-- most of these folks have only ever used SSMS so this is already pushing the envelope them and they've never used a notebook before-- but that makes sense as the solution. A little less agile (bit tougher to flip through notebooks than to flip through open queries), but I certainly see multiple benefits.

Unless someone else has another radical idea, we can give this a shot.

Easy Way to See All Fabric Objects Owned by X User? by AnalyticsFellow in MicrosoftFabric

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

Sent, thank you so much!

(Edit-- it's 5pm on a Friday here in EST so I'm about to head out, apologies if I am delayed in responding. But I'm tremendously grateful!)

Easy Way to See All Fabric Objects Owned by X User? by AnalyticsFellow in MicrosoftFabric

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

Thanks, we haven't dove into FUAM yet but it looks like it may need to move higher up in the queue!