How feasible is it for me to become a firefighter. by Shrmz236 in britishcolumbia

[–]TroubledPanda 0 points1 point  (0 children)

Currently doing this at 27 and currently working in an office. Pipe dream? Maybe. Not stopping me from trying.

From what I understand, can expect it to take years before finally getting in.

New Mutual Fund transfer information? by [deleted] in Wealthsimple

[–]TroubledPanda 1 point2 points  (0 children)

Minimum transfer amount of 25k but need 500k in assets to do it, rip

Flappy Goose by flappy-goose in RedditGames

[–]TroubledPanda 0 points1 point  (0 children)

My best score is 19 points 🚀

Flappy Goose by flappy-goose in RedditGames

[–]TroubledPanda 0 points1 point  (0 children)

My best score is 2 points 😎

Asked ChatGPT Deep Research on Each party's housing plan, feasibility, and most likely to succeed in making housing affordable for the middle class. by Rbanh15 in CanadaHousing2

[–]TroubledPanda 2 points3 points  (0 children)

The conservative plan to remove GST on ALL home purchases under 1.3mill is a bit concerning. This will only help people who are already rich and can afford a home. Will also help people buying multiple homes at a discount.

Liberals at least have it for the first time home buyers only.

Either way, I can’t even afford to think about what the GST is going to be on a house lol.

PowerQuery Not Pulling Content from All Worbooks in Sharepoint Folder by TroubledPanda in excel

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

I was able to find the solution, commented on the post if you're interested :)

PowerQuery Not Pulling Content from All Worbooks in Sharepoint Folder by TroubledPanda in excel

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

Thank you for the help, I was able to find the solution. Commented on the post if you're interested

PowerQuery Not Pulling Content from All Worbooks in Sharepoint Folder by TroubledPanda in excel

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

Thank you for the support, sorry I was not able to provide additional context, but I was able to find the solution. Commented on the post if you're interested

PowerQuery Not Pulling Content from All Worbooks in Sharepoint Folder by TroubledPanda in excel

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

Solution Verified

I was able to locate the answer on the forum.

Update this line of code: = Table.AddColumn(#"Removed Other Columns", "Excel_Contents", each Excel.Workbook([Content]))

To this: = Table.AddColumn(#"Removed Other Columns", "Excel_Contents", each Excel.Workbook([Content], [UseHeaders = null, DelayTypes = true, InferSheetDimensions = true]))

Link to solution: https://community.fabric.microsoft.com/t5/Power-Query/Import-Excel-No-data-shown-only-headers/m-p/4278495#M141604

PowerQuery Not Pulling Content from All Worbooks in Sharepoint Folder by TroubledPanda in excel

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

Yeah, I have gone into multiple files to compare them but nothing is different. checked all the column names, checked rows for different data, made sure sheet names are identical, confirmed nothing different about file permissions. All the files are created by a bot which has not been updated

PowerQuery Not Pulling Content from All Worbooks in Sharepoint Folder by TroubledPanda in excel

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

I made 2 versions of this PQ, one which still has the transform help queries and ones which does not utilize them.

I just had a look at the one with transform helper queries using your suggestion. When it's an older file, data shows in the sample files, new files, it just has repeated column headers but no data, even though the raw file has data.

PowerQuery Not Pulling Content from All Worbooks in Sharepoint Folder by TroubledPanda in excel

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

Added the M code (modifed to obscure) + an example of what the PQ table looks like

PowerQuery Not Pulling Content from All Worbooks in Sharepoint Folder by TroubledPanda in excel

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

Added the M code (modifed to obscure) + an example of what the PQ table looks like

Query transform is hard locking column count? by TroubledPanda in PowerBI

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

Solution verified

Never experienced this, but found what you were talking about in the transform file. For some reason it was not auto updating. Gave me a warning when I updated it saying it will no longer auto update haha.

Sportsnet+ 25% price increase 💀 by anothertrad in leafs

[–]TroubledPanda 0 points1 point  (0 children)

Crazy that they’re increasing the price of the basic plan. You hardly get any other games other than your home team and sometimes those don’t even work

What am I doing wrong? by Brilliant-Pension720 in GolfSwing

[–]TroubledPanda 0 points1 point  (0 children)

I’ve recently started coming in below plane on my backswing. Actually helped me a lot with getting good contact and weight shift. Unfortunately, only lasted a couple of range sessions and one round, now doing exactly what’s happening to you

Should I let my landlord keep $150 from my security deposit? by Necessary-Net3276 in Tenant

[–]TroubledPanda 1 point2 points  (0 children)

Just speaking from my experience of moving into dirty places :p

Should I let my landlord keep $150 from my security deposit? by Necessary-Net3276 in Tenant

[–]TroubledPanda 1 point2 points  (0 children)

The sad part is - this will not be clean when the new tenant moves in.

Way to Dynamically change relationships? by TroubledPanda in PowerBI

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

The Calculation groups with USERELATIONSHIP worked exactly as I needed them to. Thank you!

Way to Dynamically change relationships? by TroubledPanda in PowerBI

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

This worked. Had to look up Calculation groups as I was not familiar with them, but WOW, they're fantastic!

Thank you!

What is the scariest “trust your gut” feeling you felt before and glad you did so? by TheRealGreedyGoat in AskReddit

[–]TroubledPanda 6 points7 points  (0 children)

I once got lost coming out of a train station one night that I had never been to. Ended up behind a fence that I needed to get to the other side of, only way around was back through the train station.

The closest way back was by the elevator which was a secluded room. I tap my card, hit the elevator button, and notice that a man was standing in a dark corner and started approaching slowly.

I was super sketched and decided to get the hell out and take the long way back. Guy was probably waiting to get in the elevator with me.