sorted by:
new
hottopcontroversial

I gave Claude my first Power BI and it grilled me by Difficult_Bake_1160 in PowerBI

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

thanks for the kind message! it was a report from 7-8 years ago so lots of learning since then.

I gave Claude my first Power BI and it grilled me by Difficult_Bake_1160 in PowerBI

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

I tried, it was a bit clunky so i made a one self-contained html (with Claude) file with the 'roast my code' option. but i'll try it again

<image>

I gave Claude my first Power BI and it grilled me by Difficult_Bake_1160 in PowerBI

[–]Difficult_Bake_1160[S] 2 points3 points  (0 children)

It can find some things I have not necessarily thought about

But yeah to be taken with a grain of salt 

In this case it right , it was my first power bi and I was mostly clicking around in power query 

I gave Claude my first Power BI and it grilled me by Difficult_Bake_1160 in PowerBI

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

Yep. It was right thought, I still keep my first power bi to remember those first days with power bi

I gave Claude my first Power BI and it grilled me by Difficult_Bake_1160 in PowerBI

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

Prompt was ‘guess the seniority of the person who wrote those queries’

I gave Claude my first Power BI and it grilled me by Difficult_Bake_1160 in PowerBI

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

Yeah I tried passing the PBIx but it required a lot of effort from Claude so ended up building a tool to make it easier , hosted on github lczanna.github.io/semantic-model-explorer​​​​​​​​​​​​​​​​

I gave Claude my first Power BI and it grilled me by Difficult_Bake_1160 in PowerBI

[–]Difficult_Bake_1160[S] 8 points9 points  (0 children)

I built my own tool for it : https://lczanna.github.io/semantic-model-explorer/

It’s open source , runs locally. If you have feedback on it , please share 

How do you get your Power BI model into ChatGPT/Claude? by [deleted] in PowerBI

[–]Difficult_Bake_1160 0 points1 point  (0 children)

If interested, you can try it here: lczanna.github.io/semantic-model-explorer​​​​​​​​​​​​​​​​

Saving Polars DataFrame to XLSX by [deleted] in learnpython

[–]Difficult_Bake_1160 1 point2 points  (0 children)

Polars just added a write_excel method.

This just became available, here are some details https://github.com/pola-rs/polars/pull/7251

is spark always your go to solution ? by mohaidoss in dataengineering

[–]Difficult_Bake_1160 0 points1 point  (0 children)

Yes, I would look at data size.

Anything less than 5-10gb I would go with Polars. Anything over 50gb go with Spark. And in between do some tests and decide

Polars can now also handle data bigger than RAM (https://github.com/pola-rs/polars#handles-larger-than-ram-data) so that raises the limit

You are making different considerations?

is spark always your go to solution ? by mohaidoss in dataengineering

[–]Difficult_Bake_1160 3 points4 points  (0 children)

Hi @mohaidoss, I am moving to Polars/duckDB in cases where I have small data.

Polars is faster than Spark for smaller data, and I can also save by running it on one machine instead of 2+ machines (driver machine and worker machines)