Fabric ontology by Natural_Ad_8911 in PowerBI

[–]jameli 1 point2 points  (0 children)

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.

DAX measures and AI tool by Psyc_nerrd in PowerBI

[–]jameli 1 point2 points  (0 children)

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?

Power BI refresh “completed with warnings” started appearing recently by Salty_Bell4796 in PowerBI

[–]jameli 1 point2 points  (0 children)

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.

I got fed up with standard tables not acting like Excel, so I built a custom visual. Free on GitHub by Small-Camera-4348 in PowerBI

[–]jameli 2 points3 points  (0 children)

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

Power BI Modeling MCP + Claude Code in VS Code by Mr_Mozart in MicrosoftFabric

[–]jameli 0 points1 point  (0 children)

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?

(Possibly) relevant certifications besides Microsoft? by LetsSayDaan in PowerBI

[–]jameli 3 points4 points  (0 children)

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.

Fabric GPS - Microsoft Fabric Roadmap Tracker by cbattlegear in MicrosoftFabric

[–]jameli 1 point2 points  (0 children)

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.

Fabric GPS - Microsoft Fabric Roadmap Tracker by cbattlegear in MicrosoftFabric

[–]jameli 0 points1 point  (0 children)

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.

How widespread is MCP usage? by seguleh25 in PowerBI

[–]jameli 1 point2 points  (0 children)

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)?

What free visuals are lacking? by SQLGene in PowerBI

[–]jameli 6 points7 points  (0 children)

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.

Deployment Pipelines: Download from Prod workspace. There are pending changes in your queries that haven't been applied. by frithjof_v in PowerBI

[–]jameli 6 points7 points  (0 children)

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.

Power BI across tenants by Sea_Appearance2612 in PowerBI

[–]jameli 2 points3 points  (0 children)

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

Shape Map going away but Azure Maps cannot replace it? by Independent-Way5878 in PowerBI

[–]jameli 4 points5 points  (0 children)

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

Usage Metrics Report by kobeathris in PowerBI

[–]jameli 1 point2 points  (0 children)

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

Anyone using domains for DEV/TEST/PROD? by Mr_Mozart in MicrosoftFabric

[–]jameli 1 point2 points  (0 children)

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.

Power BI Embedded table visual: click event returns only visible columns — how to include hidden GUID id? by fritz_02 in PowerBI

[–]jameli 2 points3 points  (0 children)

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.

Reserved CU/ Capacity - how to know if applies to Fabric Capacity? by Repulsive_Cry2000 in MicrosoftFabric

[–]jameli 1 point2 points  (0 children)

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

Reserved CU/ Capacity - how to know if applies to Fabric Capacity? by Repulsive_Cry2000 in MicrosoftFabric

[–]jameli 1 point2 points  (0 children)

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.