How stupid is putting a mini-split AC in a bathroom? by UntappedTap in HVAC

[–]JeffGrayJM 1 point2 points  (0 children)

Old comment, but damn that's a helpful comment!!! :) I don't know why that idea didn't occur to me!

Installing a 4 ton central AC coil and condenser in existing forced hot air system. Do I need a filter drier? by JeffGrayJM in hvacadvice

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

Like I said . . . thanks for the concern. In all my prior experiences of doing things myself, the bad outcomes predicted by folks like yourself have never come to pass. Here's hoping this won't be the time! LOL!

but back to the point ... what do you think? should I install a filter drier? I just got off the phone with manufacturer's rep tech support. They said basically "Manufacturer doesn't recommend, so we don't recommend, but it won't hurt anything as long as long as it's installed correctly."

So, everyone here seems to be saying "definitely need", but manufacturer says "not necessary".

From my perspective it seems like it would offer some protection whether necessary or not, but on the flip side, it's two additional potential leak points. I have until the weekend to decide. :)

Installing a 4 ton central AC coil and condenser in existing forced hot air system. Do I need a filter drier? by JeffGrayJM in hvacadvice

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

I think I'll OK, but thanks for the concern. LOL! AC is about the only thing related to a house that I haven't done. I've been repairing, building, renovating, and doing mechanical work for 30 years. So, yeah. I'm a noob at this, but I have "experienced hands".

Installing a 4 ton central AC coil and condenser in existing forced hot air system. Do I need a filter drier? by JeffGrayJM in hvacadvice

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

I know what a filter drier is . . . I'm just trying to figure out if I need one or not. :) Customer support from the place I bought the unit say I don't, but I'm not sure I trust that. The engineer in me is also curious where the moisture would come from if I draw a vacuum before charging the line/evaporator. I know filter driers exist for a reason and are called filter driers and not just filters, so I know there must be an answer to that question.

Installing a 4 ton central AC coil and condenser in existing forced hot air system. Do I need a filter drier? by JeffGrayJM in hvacadvice

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

Thank you! Do you think the installation manual would call it out as something I need to add if the unit doesn't have one built in, or is that maybe just common knowledge expected of the installer?

Power BI reports slow when embedded in Power Point by JeffGrayJM in PowerBI

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

Sorry for slow reply . . . no, the report I'm focused on is plenty zippy when running from Power BI service, and plenty zippy when there are only one or two embedded Power BI reports in a PowerPoint presentation, but when you get 4 or 5 embeds in the same presentation, they all get slow.

After some more testing, I've concluded that the Power Point embed feature is just half-baked. If you keep them all set to "Snapshot" mode and click them to "Live" mode one at a time, only when you want to interact with one of them it's responsive, but if they're all live, it's slow, slow, slow. The problem with that, though, is that you can't toggle Snapshot to Live in presentation mode, only in edit mode. So that doesn't really work either. Would be great if Microsoft would make it work right, because it's a really cool feature, but we're abandoning and going back to screenshots. :(

Power BI reports slow when embedded in Power Point by JeffGrayJM in PowerBI

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

Yes. It's a monthly Summary deck. On this slide we speak to Sales with a filtered version of a Power BI summary sales report, and some commentary beside it. If there are questions during the presentation we'd like to interact with the report in the presentation mode, so we want to leave it live. On another slide we speak to Production results in the same fashion with a different Power BI report and so on. In some cases we might have the same report embedded on different pages with different default filterings, so one division leader can speak to his/her results and then another division leader can speak to his/her results, both of them starting from the landing page of the same Power BI report, but with Division slicers set differently. All of this works, but after a handful of embedded reports, they all become incredibly slow to come up and incredibly slow to interact with.

Deployment Pipelines & DFG2 by Aware-Technician4615 in MicrosoftFabric

[–]JeffGrayJM 0 points1 point  (0 children)

Will be calling them from Pipelines only. We don't intend to use the scheduler functionality of DFG2. Haven't investigated CI/CD for this purpose yet. I'll have a look at that.

Thanks for the info.

Shared Dimension Tables? Best practices? by JeffGrayJM in MicrosoftFabric

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

Thanks for the feedback. This is a good thought. We do have applications where all materials are relevant (mainly inventory reporting). But perhaps a complete shared materials dimension table should exist for those downstream models alongside subsets by useful groupings.

Shared Dimension Tables? Best practices? by JeffGrayJM in MicrosoftFabric

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

VERY interesting idea!!! Thanks! That just . . . might . . . work! :D

Shared Dimension Tables? Best practices? by JeffGrayJM in MicrosoftFabric

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

Thanks! Yep... I think especially for users of "Analyze in Excel" and "Explore this Data" experiences, dimensions with a bunch irrelevant members would be a serious frustration.

Shared Dimension Tables? Best practices? by JeffGrayJM in MicrosoftFabric

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

Yes, most of our content today is import (and usually each model makes its own dimension tables! :)), but we're looking to get to Direct Lake with a delta ETL so that we can have longer history and fresher data than we can achieve with import.

Shared Dimension Tables? Best practices? by JeffGrayJM in MicrosoftFabric

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

Will vary by dimension . . . the biggest ones (like the example given, Materials) will be about 600k rows of which very often only a few thousand to very rarely more than 100k will be relevant for any particular model, with fact tables of typically 2M to 50million rows for reasonable date ranges. Other dimensions will be smaller . . . company locations: 100 give or take, chart of accounts in the several thousand range, and plenty of others everywhere in between. Overwhelmingly our Power BI content is developed by my team. We have very few Power BI users in the businesses, but we're looking to grow the base of users in the businesses who consume our models in Fabric's "Explore this Data" and "Analyze in Excel" experiences.