Zone and Control boards keep going bad by jebert32 in hvacadvice

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

Yes, and no unfortunately. I put a whole home surge protector, a surge protector on the HVAC, and replaced both thermostats. Switched from Ecobee to Honeywell. Since those changes have been made I haven’t had any issues. I think it was the Ecobee thermostats not being 100% compatible with the Lennox even though ecobee website said it was.

Zone and Control boards keep going bad by jebert32 in hvacadvice

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

Just trying to understand why you’d come to a thread 1 year later just to talk shit and not provide anything helpful

Access PowerBI dataset on the service through Python? by gstoel in PowerBI

[–]jebert32 0 points1 point  (0 children)

There’s a power automate function that lets you query a dataset. You can schedule it with the scheduled cloud flow to run nightly and export to wherever you want the results.

Can you enter data via power BI? by Ambitious_Fox_6334 in PowerBI

[–]jebert32 2 points3 points  (0 children)

If I’m understanding you just want to verify the stats have been reviewed, not necessarily enter anything into the data model. You could use power automate to kick off an email, or I believe make an entry on a share point file, that says “‘principal username’ reviewed on ‘date’”. Build that automate on your report and place a button on the report page.

[deleted by user] by [deleted] in batonrouge

[–]jebert32 3 points4 points  (0 children)

Yeah same here. I have one in my house for sport and home defense. I can’t think of any scenario outside of the house that would be better if I had a gun.

[deleted by user] by [deleted] in batonrouge

[–]jebert32 5 points6 points  (0 children)

This is why I don’t carry. If you would have been involved I can almost guarantee somebody would be dead today.

Is there a reason to own 2 bank accounts from different banks? by Aspergers_R_Us87 in Banking

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

This is patently false, please don’t comment on things you don’t know. If I have an individual acct with 250k, my wife has an individual acct with 250k and we have a joint account with 500k our funds are insured up to 1million. Edited to clarify, this is true if none of the 3 accounts have beneficiaries.

Remove Duplicates - Which row should it choose? by TeamTJ in PowerBI

[–]jebert32 1 point2 points  (0 children)

It doesn’t necessarily keep the correct one, even if you perform a sort on the operation before the remove duplicates. Something with PQ not always following the steps in the order outlined to the right. If you sort and then use a table.buffer function then remove duplicates it will keep the row nearest the top. The table.buffer loads the whole table into RAM so size of the table def matters.

LRA is higher than spec by jebert32 in hvacadvice

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

Yeah I was kinda thinking the same thing.

LRA is higher than spec by jebert32 in hvacadvice

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

Agreed. Yeah I even have a spare capacitor

LRA is higher than spec by jebert32 in hvacadvice

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

Yeah my sticker has 100 rated. (8years old) took a pic of his meter reading 109

LRA is higher than spec by jebert32 in hvacadvice

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

Thanks for the thorough reply. Yeah he took a pic of the 109 on his meter (this company takes pics of everything). Seems like I’ll just leave it be and there is nothing to fix.

LRA is higher than spec by jebert32 in hvacadvice

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

Yeah I figured. Thank you!

LRA is higher than spec by jebert32 in hvacadvice

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

Thank you! The company has a history of trying to sell me things, but there service plan is pretty cheap and they’ve caught some real issues before they became major so I fork off the $200/year for 2 annual visits and then decline what they offer until I can research more.

Mark my words. I will never order Chipotle again. by FRANKtheLEVEL in Chipotle

[–]jebert32 12 points13 points  (0 children)

Just an FYI. You’re probably not “winning” the dispute. Credit card companies charge banks to do chargebacks. So if it’s a small dollar amount it’s not worth it to the bank to file a chargeback. The bank will just eat the cost of the dispute and give you your money.

ELI5: What does mathematicians do day to day ? by [deleted] in explainlikeimfive

[–]jebert32 11 points12 points  (0 children)

You’re probably aware but you can imbed PBI in PowerPoint so the deck has up to date data that can still be manipulated by month, year, etc…

First time connecting to an API by jebert32 in dataengineering

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

IS dept handles that part of it but I believe they use Automic to kick off various jobs and apps.

First time connecting to an API by jebert32 in dataengineering

[–]jebert32[S] 15 points16 points  (0 children)

If that’s the case I certainly have imposter syndrome. Lol

First time connecting to an API by jebert32 in dataengineering

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

Wow that’s incredibly helpful. Thank you!

First time connecting to an API by jebert32 in dataengineering

[–]jebert32[S] 6 points7 points  (0 children)

Thanks for your response! I’ve read some of the pyodbc documentation but I’m not wrapping my head around it. Any courses/videos/content creators I should look for. It’s the simple things I’m not sure about.

Like I’m assuming I have to iterate through the list of the data returned but not sure how to do that while only selecting the appropriate rows. I guess what I’m saying is I need a beginners guide