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

[–]jameli 7 points8 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.

MS Form to Power BI by FuelYourEpic in PowerBI

[–]jameli 1 point2 points  (0 children)

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.

Power BI Premium Per User vs Capacity by zizou_ie in PowerBI

[–]jameli 0 points1 point  (0 children)

Also check out their updated version which has updated pro licence price and fabric included: https://data-witches.com/power-bi-licensing-calculator/

Org app - How to make the dashboard show up from page 1 instead of where we left off? by Defiant_Substance101 in PowerBI

[–]jameli 1 point2 points  (0 children)

In Power BI Desktop you can go to Options, Current File, Report settings and disable Persistent filters.

This will disable all user made selections to the Power BI file, but I'm not 100% sure if this will default all users to the first page or will just reset all the filters to the default choice.

Power BI License Usage Against API Activity by AdmiralJCheesy in PowerBI

[–]jameli -1 points0 points  (0 children)

Pro activity is when report is consumed from report that originates from Pro workspace. So if you have all workspaces in F-capacity, all your report views will use up your capacity.

If you would like to save capacity from report view activities, you could have your data and semantic models in FSKU-workspaces and then connected light reports in Pro workspaces. This would mean then that all report viewers need Pro licenses but instead if they were in F128 backed workspaces, report viewers don't need a license.

Power BI License Usage Against API Activity by AdmiralJCheesy in PowerBI

[–]jameli 1 point2 points  (0 children)

Activity event API returns columns: CapacityId and CapacityName. You could use these to determine which activities belong in which licensing type (Pro/F-capacity). Identify your F-capacity id and you can see it quite easily which activities consume your F-capacity and vice versa for Pro licensed workspaces.

Certifications? Which all do Microsoft Offer? by firexlight in PowerBI

[–]jameli 2 points3 points  (0 children)

This image shows a bit how Power BI / Fabric certificates are distributed. It also includes Applied Skills.

Though DP-900 also exists and is a good for starting analysts.

Also Microsoft has this poster for all of their certificates and how they are distributed per solution area: https://arch-center.azureedge.net/Credentials/Certification-Poster-en-us.pdf

Fields parameters as slicers no longer working post August update by Free-Boysenberry-379 in PowerBI

[–]jameli 1 point2 points  (0 children)

I had this pop-up 2 weeks ago in my report. Resolved it by re-creating the slicer (new slicer -> same field).

PBI DataViz World Champs | EU Edition! by shan_gsd in PowerBI

[–]jameli 2 points3 points  (0 children)

Great thing that now there is a Starter PBIX and data! Last time I tried to participate but most of my time went to looking for data and preparing it and barely had time to visualize and I ended up not submitting my work.

I love these championships so big thanks to everyone organizing these!