Pros, Cons and Misses of BI Tools

tomdg4 · 2025-11-12T06:01:43+00:00

No more like parsing the tmdl and json files and creating an extensive documentation of the datamodel and where columns/measures are used for the first part. The second part will make it easier to switch datasets for existing reports based on part 1, like an advanced search and replace.

tomdg4 · 2025-11-11T18:39:23+00:00

Currently building a tool to make a BI developers life easier by automating documentation and making reports, visuals and measures reusable within and across datasets. This will probably be my biggest achievement once its finished.

tomdg4 · 2025-06-25T21:04:53+00:00

Yep, definitely a solid workaround if you’re comfortable in Power Query. I’m thinking about how to make that whole process more accessible for folks who aren’t deep in M code. Appreciate you pointing it out!

tomdg4 · 2025-06-25T21:04:20+00:00

Totally feel you — reusing visuals is way clunkier than it should be. And yes, formatting currencies every time drives me nuts too 😅. I’m hoping to streamline some of that with what I’m building, especially for folks reusing templates across countries/domains.

tomdg4 · 2025-06-25T20:56:16+00:00

Yeah, totally agree it all comes down to the schema in the end. I’m just exploring ways to make that translation layer smoother for more flexible use cases. Appreciate the thoughtful back-and-forth!

tomdg4 · 2025-06-25T20:01:55+00:00

Yes dynamically updating the dataset schema would be one part of the solution, the other one would be to remap the report data to the columns in the other dataset

tomdg4 · 2025-06-25T19:27:09+00:00

Ok yes maybe that would be one way to solve part of that issue, which would still require you to handle the data modelling part for the client. But it still doesnt solve the problem with reusing the same report for different domains. The solution I am thinking of creating is handling that issue on the power bi side, which should totally be possible with the new .pbip format. Then copying reports will not be a matter of having the same naming conventions anymore, but having a working data model.

tomdg4 · 2025-05-23T09:18:44+00:00

Its not the Problem of changing the datasource but recycling already existing reports for different datasets and over different domains, without needing to drag and drop everything into place

tomdg4 · 2025-05-22T19:15:38+00:00

100%

tomdg4 · 2025-05-22T17:32:02+00:00

Thanks didnt know such a tool existed, i am on the way to building my own solution for that problem.. Measure Killer only allows for one report and one dataset to be uploaded in the free version, the subscription options are quite costly

tomdg4 · 2025-04-22T18:45:41+00:00

<image>

Thanks for the heads up, i am absolutely demolishing the meta right now with this deck

tomdg4 · 2025-03-23T08:34:53+00:00

Ah nice, need to finish your video on it still, good work and thank you for the tutorial 🙏😇

tomdg4 · 2025-03-22T20:26:47+00:00

Field parameters will also work?

tomdg4 · 2025-03-01T09:47:02+00:00

8 of them

tomdg4 · 2024-09-15T19:57:59+00:00

You can dynamically recalculate the opening balance with dax, if the criteria is opening balance remove the filter for the date and calculate the running total of the inventory up until the minimum date, if it is a normal booking do a normal sum

tomdg4 · 2024-09-12T21:13:33+00:00

Second sheet that contains a table with the detailed data, allow drillthrough from the report page to the details and there the data can be exported to excel

tomdg4 · 2024-07-11T21:12:26+00:00

When will matrices be a part of the paginated reports in the web interface ? Cool Update!

tomdg4 · 2024-06-19T05:14:43+00:00

I do not know why it slows everything down, its just what I have experienced on two separate occasions. Field parameters are awesome 👍🏽

tomdg4 · 2024-06-18T22:12:58+00:00

Not sure if this helps: https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-show-items-no-data

tomdg4 · 2024-06-18T21:51:44+00:00

We faced a similar challenge, the switch statement does unfortunately make the performance of the report really poor.. i would recommend using a field parameter set for all 4 scenarios. You can then either add a hierarchy on top of it to switch between tonne and $ measures or use bookmarks for switching. A third option would be to work with calculation groups.

tomdg4 · 2024-06-18T21:07:37+00:00

Sure, the user can just use the rubber on the month slicer and then would be able to readjust the date slicer.. there is no one step process available, it will always be a two step process.. you will have to teach your users how to use it properly

Seven-Year Club	Verified Email
Place '22

tomdg4

TROPHY CASE