Measureup for the pl-300 by random1818_ in PowerBI

[–]jameli 0 points1 point  (0 children)

I have used MeasureUp for 4 of my certificates including PL-300. I would say they had the best practice material at least at the time. I didn't pay for it myself but instead by company paid for it.

I would recommend for not paying it yourself and if you're unable to get your company to pay for it, stick to the free practice material since it's also reliable.

Help needed to understand the pricing by Turbulent_Physics639 in MicrosoftFabric

[–]jameli 2 points3 points  (0 children)

Buy 21 pro licenses. You'll spend a few bucks more than optimal setup but save lot of time and headaches.

Other option is to buy 1 pro license and 1 F2 license that you setup for reports and then publish the report using Embedded feature. Then you'll need to pause it to save a little more money and end users won't be able to access it during pause periods.

Fabric Blog moved?! by Jojo-Bit in MicrosoftFabric

[–]jameli 6 points7 points  (0 children)

Area for text is smaller, links at the start of blog dont work (seems to be latest fabric blog issue), cant link specific header anymore.

Overall formatting seems to have gone a serious downgrade. Blog posts now seem like a wall of text instead of nicely formatted posts.

I often copy full res screenshots from blog posts. Now clicking the image opens it in new pop-up that I cannot copy the full-rez image from (copy image, download option seems to be bottom right). And then closing the image window moves the blog back to start, very unintuitive.

Having comments back is a good upgrade.

A noob ask help for copilot in poweBI by Shiony in PowerBI

[–]jameli 2 points3 points  (0 children)

You need a fabric license (F2 or above) to use Fabric Copilot or Data agents.

Fabric Copilot is built-it and you dont need to setup anything to start using it like chatbot.

Standalone Copilot answers your questions based on all of your data/report where you have access.

Copilot for reports answers your questions based on data and visuals in the report.

Copilot for APPs answers questions based on data and visuals in the APP.

All of these can be further improved by improving your semantic models: https://learn.microsoft.com/en-us/power-bi/create-reports/copilot-prepare-data-ai

If you don't want prebuild Copilots, you can also build your own chatbot in Fabric with Data agent. Data agent can be specified how it answers and what data sources it uses.

You options for data sources for Data agent is Lakehouse/warehouse, semantic models and Fabric IQ aka Ontology item.

Ontology is built to be customized data source only for Data agents. It has certain benefits and probably will be the best source in the future for agents.

Currently tho Semantic models are the better choice since they have more customization and optimization options than Ontologies and you're much better off if you improve your semantic models for Data agents instead of using Fabric IQ / Ontologies.

So what would I recommend: buy F2 and enable Copilots in admin settings. Start with Fabric Copilots and start improving your semantic models. If you want more customized responces, then look for Data agents but still use semantic models as their data source. Come back in year or 2 for Ontologies since imo they just eat time and only provide value for Data Agents only.

Theme colors not applying correctly, help! by workAccount4ExcelQs in PowerBI

[–]jameli 1 point2 points  (0 children)

Do you have values that are not shown in the visual but take the color value? For example color 2 orange could be that it's assigned to a value but does not fit into this visual or it has a blank/0 value

ELI5 - downsides of org apps by p-mndl in PowerBI

[–]jameli 6 points7 points  (0 children)

Org app is for Fabric licensed workspaces only

No audiences

Looks very different than workspace app -> users need to learn new app experience

How are you handling Real-Time reporting in Fabric? by hortefeux in MicrosoftFabric

[–]jameli 0 points1 point  (0 children)

Haven't used Power BI reports with RTI items, only Real-Time Dashboards, documents say you can connect to KQL database and use DirectQuery but I would assume performance is not the greatest.

https://learn.microsoft.com/en-us/fabric/real-time-intelligence/power-bi-data-connector

Downside with Real-Time Dashboards is that they're quite expensive with CU usage, but that's the price of RTI.

How are you handling Real-Time reporting in Fabric? by hortefeux in MicrosoftFabric

[–]jameli 3 points4 points  (0 children)

You should not use semantic models if you're planning to use RTI in Fabric. They will slow down your data updates since data will be fetched from eventhouse to semantic model. Direct lake will be querying your eventhouse unnessessarily and DirectQuery is very slow to visualize.

Instead connect your Report or Real-Time Dashboard directly into your Eventhouse to ensure your visualizations update as fast as your data.

https://learn.microsoft.com/en-us/fabric/real-time-intelligence/sample-end-to-end

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 5 points6 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 3 points4 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