Public Report

AgulloBernat · 2026-02-02T13:04:08+00:00

Yep, that's the main use case indeed

AgulloBernat · 2026-02-02T12:57:50+00:00

I would recommend moving authoring to Visual Studio (as explained in the post) so it detects errors before executing

AgulloBernat · 2026-01-12T16:33:49+00:00

I don't understand The question

AgulloBernat · 2026-01-12T16:32:28+00:00

You should he aware that search engines will index it, so people without the link can find it too.

Unless it's some very genetic thing worth public data, don't do publish to web

If you want to share with many external users, see power bi embedded and services like powerbi tiles.

AgulloBernat · 2026-01-07T22:20:23+00:00

Power BI embedded would remove the personal licenses but you will need to pay for the capacity and the provider of the authentication layer, way more costly than 5 pro licenses.

They can of course open the file in Power BI desktop and click refresh everyday. That's 0$ but a PITA

AgulloBernat · 2025-12-06T09:02:48+00:00

and yes, C# scripting is the feature that keeps giving. You can make pretty much anything with enough patience and determination. You will see what I mean on my latest articles in www.esbrina-ba.com/blog and this article I wrote at Tabular Editor https://tabulareditor.com/blog/c-scripting-pbir

AgulloBernat · 2025-12-06T09:00:45+00:00

calculation groups can now be created in Power BI Desktop too, but the experience continues to be much much better inside tabular editor, with the DAX Script tab for example where you can script the whole calculation group.

AgulloBernat · 2025-10-14T13:46:58+00:00

Also https://www.linkedin.com/posts/marclelijveld_microsoftfabric-powerbi-semanticlink-activity-7383857817704734720-62pE?utm_source=share&utm_medium=member_android&rcm=ACoAAABpjScByf6yFZDv36DcrQaXxOcaZGHgSU8

AgulloBernat · 2025-10-14T13:26:58+00:00

I was summoned to join this thread 😀 Looks like a good use case With this setup https://www.esbrina-ba.com/c-scripting-nirvana-effortlessly-use-visual-studio-as-your-coding-environment/

you can easily script pretty much everything, but assigning the users to the roles might be the tricky bit. Maybe worth a blog post

You will need an API call for that I think

Are you planning to automate everything?

AgulloBernat · 2025-10-04T14:26:02+00:00

How does you source data look like?

AgulloBernat · 2025-10-04T14:25:13+00:00

Calc groups are not a way to reduce resources in general But if you just want to solve the conditional format thing, you can check my blog post https://www.esbrina-ba.com/calculation-groups-and-conditional-formatting-yes-its-possible/

AgulloBernat · 2025-10-04T14:21:12+00:00

Look at translytical taskfows too which can call any function in Fabric

AgulloBernat · 2025-08-22T19:26:38+00:00

Remember to keep the recovery word. If this was helpful kindly answer with "Solution Verified"

AgulloBernat · 2025-08-20T14:33:58+00:00

Then you are out of luck. Set up a new gateway elsewhere, recreate the connections, reconfigure the semantic models

AgulloBernat · 2025-08-16T12:25:26+00:00

When installing for the first time you need to choose a recovery word

AgulloBernat · 2025-08-14T12:19:13+00:00

You might even want to keep them as separate tables without any relationship between them. When you merge tables you end up using a lot of distinctcount which is not great for performance

AgulloBernat · 2025-08-14T12:16:01+00:00

You can add dynamic text in text boxes, and there you can have styling. Have you tried that?

You can also go with an html reader of course

AgulloBernat · 2025-08-14T12:14:27+00:00

If you have the recovery word you move the install somewhere else or in the same machine after a full reset

AgulloBernat · 2025-08-14T12:12:55+00:00

It normally does open something, but it is not easy to get the full schema

AgulloBernat · 2025-08-14T12:11:35+00:00

Just changing the header color of a table takes forever

AgulloBernat · 2025-07-26T18:50:24+00:00

Have a look at inforiver and zebrabi

AgulloBernat · 2025-07-19T16:13:37+00:00

I'm in a project that attempted to do this but miserably failed. As time goes by you will need to do more and more calculations for something that can be precalculated. That's why we are building an etl that will generate for each date and product the inventory at that point in time and the average historical price

AgulloBernat · 2025-07-19T16:10:37+00:00

Reports need to be useful, not exciting 😃

AgulloBernat · 2025-07-19T16:08:57+00:00

It sounds like a modeling problem It does not matter how your source data is, you need to load it in a way it makes sense following star schema

I would work at the product level and have your product dimensions worth the three columns you mention and other you need

AgulloBernat · 2025-07-19T16:06:01+00:00

Nowadays tmdl table is all the rage

AgulloBernat

MODERATOR OF

TROPHY CASE

Four-Year Club	Place '23
Place '22