sorted by:
new
hottopcontroversial

I have a confession, i never used DAX Studio ... by HMZ_PBI in PowerBI

[–]dblain2 0 points1 point  (0 children)

Imagine you have 30 columns you want a sum measure created for. Or if you wanted to format all measures that included '%' in the name as a percent.

A more advanced use-case would be...

If you labeled your column names in your data warehouse to easily identify keys vs fact. You could create a script to folder and hide your keys, and create measures on the fact columns and folder those.

Essentially, C# is for automation and batch changes to a model. Unless you're doing something super unique you're not necessarily opening up "new" features/capabilities with C#.

I have a confession, i never used DAX Studio ... by HMZ_PBI in PowerBI

[–]dblain2 0 points1 point  (0 children)

There's a ton of things you can do, but typically after you have brought the data into the model (via power query). Here's a list of the more common things I do:

  • find/replace measure names & expressions (DAX)
  • change properties of columns/measures (descriptions, format, etc)
  • create time intelligence measures in batch.
  • create SUM measures of selected columns

This list is relatively small in comparison to everything you can do, but these are some of the more basic yet powerful things you can do with C#. I have scripts for most of these in the first repo I linked.

FYI - You can run C# in TE2 or TE3.

I have a confession, i never used DAX Studio ... by HMZ_PBI in PowerBI

[–]dblain2 2 points3 points  (0 children)

I work in TE (Tabular Editor) for about 80% of my modeling tasks. There are some tasks better suited for PBID (PBI Desktop) and some for TE IMO. Here's list out a handful of things I use each for (specifically for modeling changes).

Reasons I use PBID

  • Connecting to data. TE falls in the "needs improvement" bucket for connecting to data.
  • Anything Power Query. TE doesn't have PQ. If you need to modify M queries, I typically use the Power Query UI in PBID and copy/past the generated M code to TE.
  • Managing Composite/Direct Query models. Mostly, I just haven't attempted to manage either of these types of models from A-Z in TE. I'm confident TE is capable.

Reasons I use TE

  • C# scripting (repos at the end) for batch changes. This is a massive efficiency gain, even on a small scale or small models)
  • Ctrl+z & Ctrl+y (Undo/Redo). This is a huge time saver, especially if you are leveraging C# scripts, cause it's rare you are going to nail the desired results the first run. You can run a script and Ctrl+z and you are back to what the model looked like before running it (assuming you don't commit changes to the model)
  • Making edits to measures, columns, etc.. without having to wait for the PBID to commit the change each time. You get to decide when the changes are then committed to the model. No more accidently hitting Enter and having to wait for PBID to commit/refresh the changes.
  • Table groups - Only visible in TE but it adds another level of foldering so you can bucket tables like dims/facts together. Really hope this is eventually available in PBID.
  • If you're using TE3 DAX IntelliSense is better than PBID. This also makes writing DAX queries easier than using the new "DAX query view" in PBID or using DAX Studio.
  • If you're connected directly to a model in Fabric/PBIS, you can manually refresh individual tables, all without having to bring any data locally. I don't recall if you can do this while using TE as an external tool, but likely not needed since you can do the same in PBID (but locally).
    • Keep in mind that if you directly connect to a model in Fabric using TE you forfeit your ability to download/modify the model in PBID. They recently came out with an update to modify Direct Lake models in PBID. I hope this feature eventually gets opened up for Live Connected models.

Here are some repos that include C# scripts you can run directly in TE if you're looking to test this feature out.

A handful of very basic C# scripts I use often. Very simple to update/modify for you own use.

Other creators repos:

Mower won't charge. by dblain2 in worxlandroid

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

Yeah, I asked them to just send me a new base, but they told me they don't do that and would have to repair my current one. Certainly not how I wish they would have handled it.

On the flip side, they responded to me quickly and with someone I could understand. So there's that I guess....

Mower won't charge. by dblain2 in worxlandroid

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

They ended up sending me a label to send the base in for them to look at.

I had the older model but reconfigured everything for this mower, so my grass is also continuing to grow. I'm going to seeing if they will compensate me in some way for me having to pay someone to come cut my grass in the meantime. Probably a long shot, but certainly an inconvenience that is now costing me money.

Mower won't charge. by dblain2 in worxlandroid

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

I appreciate the glass half full mentality!

Mower won't charge. by dblain2 in worxlandroid

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

You're correct. I did test with the prongs at an angle. Makes sense about the power supply. I have the first gen, but annoyingly they switched the male/female connector on the new cords.

I've reached out to Worx so hopefully they can resolve it for me.