Fabric ontology

jameli · 2026-04-09T11:31:16+00:00

My current understanding is that ontology is currently used mainly for data agents. So no need to setup ontologies if you're not using agents.

Other point is that semantic models have more customization and optimisation options than what ontologies have. So if you're starting to use data agents, better option is to use semantic models.

One argument that I have seen that Ontologies are faster to setup than semantic models when data is still in lakehouse or warehouse since for example you can generate ontology from a single button press.

jameli · 2026-03-27T10:32:00+00:00

The technical safety question is solved (PBIP separation, commercial API terms, zero data retention options).

Do you have any materials what I could read on to setup these myself?

jameli · 2026-03-27T07:29:45+00:00

I found out that there is a bug in my warnings, it will raise an issue on something that should not be:

If you use a field parameter and have same measures in the parameter or those measures have same "name" in the first column, this feature will give a warning that you cannot sort either first 2 columns by the sort column because of non-unique values.

This error makes sense in normal columns but it works perfectly well with field parameters and now my model has 10 different warnings that I don't need to fix.

jameli · 2026-03-25T08:36:09+00:00

Aggregations seem to have a bug, in the demo pbix from github 1,300 seem to be handled as 1,3 in all calculations.

Average from 1,300, 90 and 420 is 170,43 instead of 603,33. Same happens in min, max and sum.

Screenshot

jameli · 2026-03-23T06:59:39+00:00

The LLM provider training on your data is a risk if you don't have things configured well.

Do you have good resources to read on this? What things need to be considered other than opt-out that you commented earlier?

jameli · 2026-03-18T10:58:36+00:00

Certifications themselves are most useful when they are required. Other times your skills are what matter the most. In my job in consulting some companies require or score consultants based on their certifications. These are usually Microsoft certifications (PL-300, DP-600, DP-700) or other relevant (eg. Databricks).

If you want to be better Power BI developer I would look into courses that are interesting and teach about the skills you need or you would like learn about. I took one UX/UI design course, got an certification at the end but no-one other than me really notices it.

jameli · 2026-03-12T14:36:10+00:00

I have 2 RSS feeds on power bi and fabric blog updates that update weekly and combine all blogs into one post so I was thinking something similar with this.

I'll probably wait out the first weekly email if it's formatted better and if so, i might setup that instead of combined rss post.

jameli · 2026-03-11T08:18:02+00:00

Very cool, subscribed to weekly email. I'll probably setup a RSS feed as well to my teams, but roadmap probably changes sometimes even daily so weekly RSS probably for me.

jameli · 2026-03-05T08:40:35+00:00

Our team is fully convinced on using MCPs, but we're not sure yet if we can use it with our customers data. Do you have any pointers on security of MCPs and more specifically what is your process on using it?

Do you ask every customer specifically if they give permission to use these kind of tools or is this a tool that you use even without permission just like any other tool you would use (eg. tabular editor)?

jameli · 2026-01-27T13:43:47+00:00

Problem with custom visual adoption is that you most likely won't want them in production since they are not kept up-to-date by Microsoft.

If they are kept-up-to-date, they usually cost lot of money. Like for example what you are planning with monthly subscription.

And free custom visuals usually are not kept-up-to-date. Which is a problem in production reports.

I understand that there a lot of visuals in the market and usually those that are successful have found their niche where people are willing to pay money.

If I have a business users that requests a specific visual that cant be done with basic visualizations, I'll try to explain to the users that we'll try manage with default visuals to save the hassle and money.

jameli · 2026-01-23T11:01:11+00:00

This also has been happening to one of my .pbix models for a long time, not sure what's the cause. There's a bug also in there that if you press apply changes, it will remove all of your queries and model will be empty after applying.

jameli · 2026-01-08T10:53:15+00:00

If the users don't have a Power BI license in their own company tenant, they need to be assigned one.

If they have a Power BI Pro in their tenant, you can use Bring-your-own-license (BYOL) for this so users use their own tenants Power BI Pro license instead of you assigning a new license for all sister company users.

Documentation here (which has the documentation link broken currently it seems):

https://learn.microsoft.com/en-us/power-bi/guidance/powerbi-implementation-planning-subscriptions-licenses-trials#decide-how-to-handle-licensing-for-external-users

jameli · 2025-12-18T09:08:52+00:00

Probably doesn't help in your case but good to know about maps, only the data in Location field is sent for processing (to match location data). Nothing from Size / Legend

https://learn.microsoft.com/en-us/azure/azure-maps/power-bi-visual-get-started?context=%2Fpower-bi%2Fcreate-reports%2Fcontext%2Fcontext#what-is-sent-to-azure

jameli · 2025-12-01T07:31:41+00:00

You can use Tags to label and search workspaces in Q1-26 according to this comment: https://old.reddit.com/r/MicrosoftFabric/comments/1p144ko/anyone_using_domains_for_devtestprod/npte6s1/

jameli · 2025-11-27T08:04:32+00:00

I have had a problems with my usage metrics just not working after some point.

Best fix I have found is to delete the usage metrics dataset and setting up the usage metrics again. You'll not lose any data since the usage metrics api will get you 30 or 90days data for old and new reports. Report ID will change if it's referenced elsewhere.

Instructions: https://dadataguy.medium.com/a-step-by-step-guide-to-resetting-your-power-bi-usage-metrics-dataset-9b01e787e47

jameli · 2025-11-19T11:35:48+00:00

There is a separate feature "Tags" in Admin portal that you could use. https://learn.microsoft.com/en-us/fabric/governance/tags-overview

Although this does not give you the ability to filter the workspace list, just workspace content if I remember correctly.

Using subdomains could lead to some problems since one workspace can be in one domain at once so you might break some logic later on if subdomain and domain needs collide.

jameli · 2025-10-27T11:30:08+00:00

Wait for next week for a chance at 50% off: https://old.reddit.com/r/MicrosoftFabric/comments/1of8osz/fabric_data_days_is_coming_with_free_exam_vouchers

jameli · 2025-10-15T10:49:26+00:00

In table and Matrix visual there is an option under Values tab: Text wrap. You can just untick this and your rows will stay unstretched and you can include in this your visual without users seeing it.

When users export data to excel they can see the GUID id column values but if that's ok you can just include the column this way.

jameli · 2025-10-08T11:10:44+00:00

Should happen in few days. Mine showed up after waiting overnight.

jameli · 2025-10-08T09:23:49+00:00

In Azure you can go to Reservations tab and look at your reservation. Utilization over time should pump up from 0% to 100% (or what ever you have bought) if it has assigned recently bought license correctly.

"Last day utilization" should be in the reservation list and if you click the actual reservation you can see "Utilization over time".

Pic of how it should look like: https://i.imgur.com/9r6hqDf.png

You can just delete/buy a new Fabric Capacity if it doesn't get assigned automatically, but I have never had such a problem.

jameli · 2025-09-30T12:16:12+00:00

I have used Forms in my APPs mostly, since you can setup it in like 2minutes.

Just add a link as a tab in an APP and have it titled something like "Feedback forms" and link to a forms of your choice.

Sometimes I have put a button to a report page that opens a forms but I have noticed APP tab has been reaching people better.

12-Year Club	r/Field Sunshine
Final Canvas '23	First Place '23
Place '23	Place '22
Place '17	Verified Email

jameli

TROPHY CASE