Recent searches

No recent searches

Search options

Only available when logged in.
101010.pl is one of the many independent Mastodon servers you can use to participate in the fediverse.
101010.pl czyli najstarszy polski serwer Mastodon. Posiadamy wpisy do 2048 znaków.

Administered by:

Server stats:

482
active users

101010.pl: AboutStatusProfiles directoryPrivacy policy

Mastodon: AboutGet the appKeyboard shortcutsView source codev4.4.0-rc.1

#powerbi

0 posts0 participants0 posts today
James Bartlett :terminal:

Yo, #MicrosoftFabric and #PowerBI people! It's been quite a while since my last #DataDojo #PowerBICommunityOfPractice blog post, and for a very good reason.

I've been hard at work preparing a new version of the Data Dojo Power BI Report Template without any proprietary logos, themes, data connections, etc., and I am happy to announce that it is finally ready!

Guys, gals, and non-binary pals, I hereby present to you the long-awaited Data Dojo Power BI Report Template! Check out the article, download the template, take it for a spin, and let me know what you think!

datavolume.xyz/2025/03/16/Data

DataVolume.xyz · The Data Dojo: A Power BI Community of Practice (Part 5)A series about founding and fostering a successful Power BI Community of Practice
Anoncheg

Part1: #dailyreport #powerbi #datawarehouse #dwh #postgresql
#python
At this week I installed PowerBI and connect it to remote
PostgreSQL.
I asked AI to compare open-source data sources for
PowerBI and compare them by:
- Ease of Setup on Linux: SQLite > PostgreSQL > MySQL >
Redis > MongoDB
- Performance:
+ For large datasets: MongoDB > PostgreSQL > MySQL >
Redis > SQLite.
+ For real-time operations: Redis > MongoDB > MySQL >
PostgreSQL > SQLite.

For PostgreSQL I prepare data in Python script that use:
- pandas - for coverting types to datetime and numeric
- sqlalchemy - for simplifying type converstion
- asyncpg - sqlalchemy backend to connect to PostgreSQL

Continued thread
Chris Geoghooligan

Oh no… I’m wondering if this might be achievable using #Python within the confines of #PowerBI. My skillset with either on their own is limited, and I have never mixed the two into a vile concoction before.

I may have just committed myself down a rabbit hole for the day 🤦🏻‍♂️

Chris Geoghooligan

So… when you query a folder of Excel files & invoke a custom function w/ a transform file, you get a list of all items w/in the files (e.g. tables, sheets). But I’m surprised each item’s “location” isn’t provided (e.g. Table1 is located on SheetC).

I find myself having to review 100s of workbooks where people carelessly skipped rows or added info below tables. Comparing the lengths of tables vs the sheets they’re on would be VERY helpful, but the names don’t always match.
#PowerBI

SQLAllFather

I left Spotify in 2021 and started listening to my own music collection. I already had the MP3s and/or the CDs from which to rip them, so I hosted them on my Plex server and started listening to them using the excellent Plexamp mobile client.

One thing I missed from Spotify was the "wrapped" listening summary... but I'd always believed I could improve on what Spotify delivered. This winter break I spent some time implementing a solution in Microsoft Fabric. I used data from my Plex server's SQLite database for recent years, and from the JSON files that Spotify will send you if you make a GDPR data request for older years. I standardized enriched both data sets with the open source MusicBrainz database, and then visualized some Spotify-inspired vanity metrics in Power BI.

1/

#Notify#Plex#Plexamp
TrendingLive feeds
About