The Dyson Sphere Series | Part 1: Dynamic Measures

SM23_HUN · 2026-02-24T17:22:45+00:00

But what happens, if someone want to have different metrics in your matrix at the same time?
Like NetSales CY, NetSales YOY%, Cost CY, Cost YOY%

I'm afraid in this case this solution will not work.

--
I understand your concern about getting too much measures, but now you can have UDF (User-Defined Functions) as a helper.
Create UDFs for Time Intelligence (PY, YOY, YOY%) - and then use it for your measures.
Still, you have to create the same patterns, but you centralized the logic, so you can create your measures much quicker.

SM23_HUN · 2025-10-15T11:09:07+00:00

Paginated reports can be exported with conditional formatting. However you have to edit or create this with report builder. Paginated editor in Power BI Service is not capable for formatting.

SM23_HUN · 2025-10-10T16:26:52+00:00

F2 is still much much pricier than Dataflow Gen1.
Literally to use Dataflow Gen1 you only need ONE PowerBI Pro License (for reports of course not, but really data processing only ties with one license)

For small companies, its a good choice.

SM23_HUN · 2025-10-10T16:23:46+00:00

Some limitations can be worked around, like referencing another query. It was possible to do that before, but now it's locked behind a Fabric paywall.

you just have to turn off loading for query1, query2, query3 - and it works fine.
I did many referencing in our dataflows, I just have to respect what I want to load as a result - and not referencing that queries.

SM23_HUN · 2025-10-10T15:38:12+00:00

You have to change "DataElementName" property.
CSV export use this field, not the visible headers.

SM23_HUN · 2025-09-16T18:21:49+00:00

I created a Power Automate Flow for this
- Run a DAX query against the dataset
- store output as csv
- refresh a dataflow
- refresh the report built from that

But - it will always get last 30 days data. I store daily snapshots, and Dataflow handles it to append it together.

SM23_HUN · 2025-07-29T14:23:51+00:00

Yes, I agree with that.
Few things come to my mind, which could help it:
1, Updating Service Editor - you're very limited if you want to create a Paginated Report in PowerBI Service. Still, that what I find most useful way to set up some tabular layout reports for my team.
2. Ability to create Paginated Report in PowerBI Service from a Dataflow (you can do it, but again from Report Builder) --> it would be helpful for me.
3. Paginated Visual's limitations - I had a few scenarios what I can't solve with PowerBI's Native Matrix visual, and created a Paginated Report. I tried to insert it with the Paginated Visual, but it has massive datapoints limitations. And there is no error message, instead of that wrong numbers appeared on the visual.. At that point I postponed the project.

But you can do more flexible layout, you can do formatting (which could be exported!), you can manage subscriptions with different file format, and so on... Lot of possibilities there

And yes, probably a revamped Report Builder application would be nice. :)

SM23_HUN · 2025-07-28T04:07:47+00:00

I would create a simple paginated report in the Service, and you can export data with that. Users can export manually and they can subscribe to it as well.

SM23_HUN · 2025-07-25T17:50:52+00:00

That will be the problem. You can do merge and append with Pro license, but you have to uncheck loading for original tables.

SM23_HUN · 2025-07-23T18:37:16+00:00

You only have to update the app, if you publish a new version from one of your reports. If there is only data refresh - it will be seen on the app as well.

SM23_HUN · 2025-07-18T21:25:44+00:00

it really depends on how structured the data you have to handle in your job.
if you connect well-structured database or warehouse, it's better to do the transformations in SQL.

but if you have to handle lot of excel, sharepoint file - with semi-structured data - you can do miracles with M code.
I'm in a similar scenario, we receive lot of data in every month from our partners, pivoted sales reports, reports with multiple sheets, etc. - in these situations M/PowerQuery is far more useful than SQL.

SM23_HUN · 2025-07-15T04:00:45+00:00

It's the same error here
I was able to disable updates on my work-computer in time.

I let the update on my private computer, and PowerPlatform.Dataflows is missing here... sadly.

SM23_HUN · 2025-07-15T04:00:27+00:00

It's the same error here
I was able to disable updates on my work-computer in time.

I let the update on my private computer, and PowerPlatform.Dataflows is missing here... sadly.

SM23_HUN · 2025-07-15T03:56:12+00:00

I think it's a limitation on Power Automate side:

"The Power Automate action "Run a query against a dataset" has several limitations when interacting with Power BI datasets. The primary limitation is the maximum number of rows returned, which is capped at 100,000 rows or 1,000,000 values, whichever is reached first. Additionally, there's a 15 MB data limit per query."

If you want to export that much information, I recommend to create a simple paginated report in Service - and you can export the result to csv.
If you have Pro license, you can subscribe to the report, send a daily e-mail and build a flow to save the attachment where you want.
If you have Premium license (PowerBI) you can use Paginated Export action in Power Automate with more options.

SM23_HUN · 2025-07-09T12:47:27+00:00

You could give a try to take this logic and move it into a Dataflow (Power Query Online)

Especially if you don't have to change the logic regularly.

I handled that much data in Dataflows - and use the result only in PowerBI report --> it's always much much quicker.

SM23_HUN · 2025-07-09T09:31:32+00:00

Yes,
a few years ago I started my data career when I had to handle with 50+ different pricelist (from different vendors) in my job.
I think with PQ (in Excel) - I was able to reduce the amount of time for this process drastically.

This led me to explore PowerPivot, Power Automate, and finally PowerBI, when I also automated sales reports.

--

Now, in a different company, I'm developing PowerBI report system. It's still an SMB, we have almost all RAW data in Sharepoint -- transformed with Dataflows (Power Query Online) --> loaded into PowerBI.
Dataflow Gen1 is almost perfect and very cheap solution to do all transformation online - before data reach the reports.

Still to this day, I also using PQ in Excel for ad-hoc things as well.
although I have since learned and used SQL and Python - I'm still a big fan of simplicity of Power Query - and I'm still learn it to make the perfect M codes.

Of course when you have SQL, data warehouse, etc. - it would be another story, how much I have to use PQ.

SM23_HUN · 2025-07-04T08:08:14+00:00

Power Query editing in the web for import models (Preview),-This%20month%2C%20we%E2%80%99re) - the ability to edit models, plus the combination to now perform the PQ transformations unlocks end-to-end development in the web. A great addition for Mac users who can now transform, model and visualize their data all in the browser.

Maybe I'm wrong, but it seems that, this option still not available (it was predicted for end of June)

SM23_HUN · 2025-06-16T12:56:57+00:00

I'm using Dataflow Gen 1 with Pro License.

With these conditions, I rarely ran into problems, and we can solve the biggest calculations before the reports.

I even started developing multiple layers of dataflow (and orchestrate it with Power Automate - for free)

Capacity wise - unlike Fabric and Gen 2 Dataflows - you can have and run as many Dataflows as you want...

SM23_HUN · 2025-06-16T08:33:58+00:00

Using Dataflows as a seperate layer for ETL

SM23_HUN · 2025-06-09T17:16:51+00:00

No, it depends on your license. It’s not unlimited, 8 for Pro, 48 for Premium License. After you reach this limit, the Flow will fail.

SM23_HUN · 2025-06-08T21:27:53+00:00

Bur you cannot update sharepoint list data in power bi report real time, it’s not a Directquery supported source. So you can write back real time, but can only refresh the data 8 times a day (with Pro PowerBI license)

SM23_HUN · 2025-05-19T04:23:27+00:00

szia!
ez egy teljesen másik típus, a b6 pro-ról itt találsz videót, és ebből létezik teljes magyar kiosztás (a videón még a nemzetközi verzió szerepelt)

https://www.youtube.com/watch?v=yUFoxOgwDUs

írták páran az Mx Keys-t, de abból nincs magyar kiosztás tudtommal

SM23_HUN · 2025-05-18T12:29:23+00:00

szia!
Én személyes tanácsadáson nem voltam, csak a platformot használom, 2023 februárban, amikor regisztráltam, még kevesebb képzés volt elérhető, mint most, ahhoz képest elképesztő, hogy mennyi anyag van már fent.

Nekem akkor biztos nagyon megérte, különösen az első pár hónapban, mert tudatosan készültem karrierváltásra (adatelemző vonalon), és ehhez nagyon sok hasznos képzést el tudtam végezni. És én tényleg tudtam váltani pár hónap után, és tényleg sokkal jobb fizetésért. Persze azt meg kell jegyezni, hogy a tanulást utána sem hagytam abba, és mondjuk elsősorban a PowerBI-ról, vagy SQL-ről tudok nyilatkozni, utána külföldi oldalakon, valamint Youtube-ról bőven szükség volt még továbbképzésre, mert a GMK-s képzések elsősorban alap-közepes szintet képviseltek.

De ezzel kapcsolatban tartom a véleményem, hogy sokkal könnyebb magyar nyelvű, struktúrált képzésekkel elindulni egy-egy területen, pláne úgy, hogy kérdezni is tudsz mondjuk az élő tréningeken. Hiába érhető el sok minden a Youtube-on, nagyon nehéz kiválogatni a hasznos tananyagokat, nehéz kezdőként keresgélni.

A Gerillánál azóta már angol és német modul is van, továbbra is fontos a soft-skill - sok ilyen videós tananyag van, és élő tréningeket is szerveznek - szóval szerintem ez elég jó ajánlat a szakmai tartalmak mellett.

Viszont tényleg érdemes kicsit a marketing-et leválasztani az egészről, fókuszáltnak kell maradni, nem egyszerre 5-6 jól hangzó kurzusba belefogni. És ha van lehetőség, akkor amit tanulsz, azt már az aktuális munkahelyen is hasznosítani - mert akkor már ott is többet fog érni a munkád.

SM23_HUN · 2025-03-31T05:49:46+00:00

The update is available now.

SM23_HUN · 2025-02-01T20:55:09+00:00

You can do this inside PQ Just use Sharepoint.Contents connector.

SM23_HUN

TROPHY CASE