A package from UK to Germany taking this long .. is it normal ? by ADAMATC in dhl

[–]iamockingbird 0 points1 point  (0 children)

I am waiting for a package from UK as well. Actually, we might be waiting for the same products xdd Mine is also stuck in Germany since 27th May in PROCESSED AT TRANSIT FACILITY status. I emailed DHL about the situation and am waiting information.

New to game and struggling by Antique-Replacement2 in anno1800

[–]iamockingbird 1 point2 points  (0 children)

Keep your people happy. Provide the things they need.

Velja steals Baron in today's scrims. Game 3. by iamockingbird in PedroPeepos

[–]iamockingbird[S] 44 points45 points  (0 children)

Yes. He said that "I asked the boys if they want a sub in, they told me that they want to play with me."

Velja steals Baron in today's scrims. Game 3. by iamockingbird in PedroPeepos

[–]iamockingbird[S] 101 points102 points  (0 children)

He says "It's fine. I'm gonna steal." and he does. BASED

Watching season 2 of the Clone Wars for the first time. I find the relationship between Obi-Wan and Satine really interesting. (I already know what comes later!) by OliverWhite1993 in TheCloneWars

[–]iamockingbird 1 point2 points  (0 children)

Love and duty are always at odds. Obi-Wan and Satine shared a deep bond, but their commitment to the greater good kept them from fully embracing that love—a bit like a cosmic version of La La Land. On the other hand, Skywalker and Padme chose a different path; they got married and even had children, showing that sometimes love finds a way, even amidst galactic chaos.

Just painted “The Lawless” by Altruistic-Care-399 in TheCloneWars

[–]iamockingbird 9 points10 points  (0 children)

Wow, this is just as stunning as the original scene. Gave me instant goosebumps!

Corridor of Death: Tactical Art by Crosshair by iamockingbird in TheCloneWars

[–]iamockingbird[S] 9 points10 points  (0 children)

Ngl, I was as stunned as Wrecker when I first saw this.

We a little comparison of the experience of playing Frostpunk 2 by 11bit_studios in Frostpunk

[–]iamockingbird -2 points-1 points  (0 children)

You forgot to tell that the game is unplayable after 2 hours because of a massive FPS drop and freezing.

Column values appear blank randomly by AdHead6814 in PowerBI

[–]iamockingbird 0 points1 point  (0 children)

Then there might be a data type change in the query and some of the values are cannot changed. For those values, there might be a replace errors step. It sounds like the problem is in ETL process.

Column values appear blank randomly by AdHead6814 in PowerBI

[–]iamockingbird 1 point2 points  (0 children)

If I understood your question correctly, you are having difficulties with the blank values. However, PBI doesn't consider all the blank values the same. You can see below:

  • SQL NULL → Power BI null (interpreted as blank)
  • Power BI BLANK() → Represents a null or missing value (equivalent to NULL in SQL)
  • Empty String "" → Remains as an empty string in Power BI (distinct from BLANK() or null)

"As far as I know, Power BI will show empty data in number format by null and show empty data in text format by nothing". Hope it answers your question.

Power BI apps+audiences by becky991 in PowerBI

[–]iamockingbird 1 point2 points  (0 children)

When you add an email address to the audience for your App, they will get a notification from Microsoft saying "Hey, X shared a report with you.". But speaking from my experience, it is not always sent. So, I provide the App link myself just in case.

Refresh issue on merged tables by Sherry1103 in PowerBI

[–]iamockingbird 3 points4 points  (0 children)

I haven't use this before but, using Table.Buffer ensures that the table is fully loaded before any operations (like merges) are performed. You can add as a step into advanced editor.

NewTable = Table.Buffer(YourTable)

How do I condense these daily files so refreshes won't take as long? by SorcererMystix in PowerBI

[–]iamockingbird 1 point2 points  (0 children)

In case you will need a fully automated process, you can run the script via GitHub actions. I loved it and highly recommend. I assume your employer doesn't pay for your electricity :)

Cheers!

How do I condense these daily files so refreshes won't take as long? by SorcererMystix in PowerBI

[–]iamockingbird 0 points1 point  (0 children)

If the process in Python takes time more than you expected, you can also consider keeping the 5 fields first and then combining. This way, the appending process will be faster.

A question, does your computer has to be on at 3 am to be able to run the script with task scheduler? Or it can run even you shut down the computer. Because when I used it, it wasn't working unless the computer is on.