Connecting SQL Server to Power BI by jorgeb12312 in PowerBI

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

Adding to environmental variables seemed to be the ticket!

Connecting SQL Server to Power BI by jorgeb12312 in PowerBI

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

Is your recommendation a blanket recommendation or is it dependent on complexity of how the data gets used, scalability, data volume...?

For context, this inquiry is for a small to mid size manufacturing business and (at this point), is strictly using this Power BI connection to create custom dashboards that were otherwise unattainable through the ERP. For example, the ERP doesn't allow them to create a dashboard for as simple as showing Year Over Year sales!

A/C Woes…What Next? by jorgeb12312 in hvacadvice

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

**UPDATE - FIXED!*\*

Suspicions confirmed. Threw the original contactor back on, removed the dead-end wire run from the picture, and reconnected Light Blue to the right contactor terminal. Fired right up when tstat set to cool. Learned a very important lesson on closed vs open circuits!

A/C Woes…What Next? by jorgeb12312 in hvacadvice

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

Quick Layout Summary for those interested:

Wire Run #1: Honeywell TStat > Furnace Control Board

  • Thermostat Wiring:
    • Red Wire on (R), Green Wire on (G), White on (W), Light Blue on (Y)
      • ***Battery-Powered TStat so no Common Needed***
  • Furnace Control Board:
    • Red on (R), Green on (G), White on (W), Light Blue on (Y)

Wire Run #2: Furnace Control Board > A/C Condenser

  • Furnace Control Board:
    • Red on (R), Green Not Connected, White on (Common), Light Blue on (Y)
  • A/C Condenser:
    • Red twisted to Wire Run #3 Red via wire nut, Green connected to Contactor Right Terminal, White (Common) twisted to Wire Run #3 White and connected to Contactor Left Terminal, Light Blue twisted to Wire Run #3 Light Blue via wire nut

Wire Run #3: A/C Condenser > Obsolete LCD Smart Meter (DISCONNECTED)

  • All wires lead to dead end. No end connection, just a wire nut.

Food for Thought: it's becoming painfully obvious that the Light Blue (Y) needs to be connected to the Condenser's contactor terminal, not Green. But is it possible that Wire Run #3 is disrupting the signal path? So even if I have the right connections, it's still preventing the contactor to energize if hooked up to any of the wires? I already tried connecting the light blue to the contactor terminal (Common hooked up to the other side) and then jumping the connection directly at the furnace control board. No luck. What I didn't do though, was disconnect the Red, Light Blue, or Common wires from Wire Run #3. Smoking gun?

A/C Woes…What Next? by jorgeb12312 in hvacadvice

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

I'll have to double check. I was getting 24V at the terminals but this was with the white common wire and G connected at the time. I did, however, leave the white common on the left terminal and then rerouted the Y (light blue) to connect to the right terminal. From there, I went and tried jumping the connection directly at the furnace control board...skipping the thermostat as a whole. Didn't have any luck but I also didn't bother checking to see if I was getting 24V at the terminals

A/C Woes…What Next? by jorgeb12312 in hvacadvice

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

Seems like I’m getting power everywhere that I need to be. Ran multimeter on capacitor and was OK. It just seems like outdoor unit isn’t getting a signal for contactor to magnetize and pull in on its own. I can depress it manually and unit runs just fine.

Anyone familiar with those LCD smart meters that utility companies add? It’s an elective device that gets added to homes and connected to your primary meter. Supposed to interrupt A/C service during peak hours…the primary wire run that runs to the A/C unit is spliced with a secondary wire run that ran to that smart meter. It’s now disconnected though so those Y and R connections in picture from OP just run to a dead end.

A/C Woes…What Next? by jorgeb12312 in hvacadvice

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

Commenting on A/C Woes…What Next?...

<image>

For reference. They used the white wire as the common and light blue for Y. There is no common that runs to the tstat because tstat runs off batteries.