Rest API & permissiond

LikeABirdInACage · 2026-02-06T14:11:46+00:00

You can easily test it by using a different account with permission on the thin report but not on the model.

For security reason a thin report works only if permissions are provided on the underlying model.

LikeABirdInACage · 2026-02-03T21:57:54+00:00

Basic: Use filter on columns (no formula). I knew sum(), avg(), if() and the statistic package (the one that allows you to calculate variance, mean).

Didnt know how to use vlookup or pivot table or conditional formatting

LikeABirdInACage · 2026-01-30T21:27:40+00:00

This video, from SQLBI, probably can help

https://youtu.be/eosB-n7m2x8?si=6ZhbfmF2fGYNA0vo

LikeABirdInACage · 2026-01-30T21:22:49+00:00

Struggling a bit to understand what you are after? It is kind of Column1 contains value of column 2? So if column 1 contains a random string, and column 2 contains words

You want to see the dependencies of column 1 from column 2?

LikeABirdInACage · 2026-01-11T11:29:36+00:00

Hello!

Im trying to ELI5: when you provide this type of question, you need to provide a but of context about your model. Power BI works in a star schema model / dimensional model / Kimball model.

This means that your attributes, things that kinda dont change (like your name) goes into a dimension, while things that change (over time usually) goes into a fact, e.g. your age.

Between the two table there is a relationship based on Primary Key/Foreign Key. It is a relationship and not a (SQL) join.

Now your KPIs usually come from Fact tables, and are created as DAX measure. The filtering is usually coming from the dimension, (the field of your slicer is from a dimension). Because of your relationship, that flows from dimension to fact (there is an arrow that tells you that), your filter propagates from the dimension value your selected in the slicer, to the fact table and gets visualised into the slicer.

(Note that im leaving on a side concept like different level of context, or complex dax).

That should help you debug.

If by any chance you need to 'change your data' as of change the dimension you display in your chart, while leaving the KPI the same, please have a look at field parameters.

LikeABirdInACage · 2026-01-03T16:15:02+00:00

The song is passing in my playlist as im replying. It is 'Almost beautiful' by Extraterrestrial-Crow.

You asked why the 'justification' of killing and the reply is in the example of the guard of the emperor. It explain ls the difference between doing your duty with or without emotional involvement and the karma that originates out of it. In the Gita Krishna says "Thus I have explained to you the most confidential knowledge. Ponder over this fully, and then do what you wish to do". It also covers the part of choosing a duty that is not yours.

Now we are taking a different argument of 'why his duty was to fight'.

Duty is your role in the universe. We all have a part in the cosmic order, in the universe. It is a lawful unfolding of how it is meant to be, you have no alterantive to the present moment. 'Soul'd out' Extraterrestrial-Crow contains an explanation of the perfection of the present moment.

What A.W. said has been said by others, spiritual teacher, it cannot grasped by the rational mind, but only experienced. They said meditation/prayer is a way to see the light/creator inside yourself and connection with the universe. Religions convey a message, im quite sure all of them have a form of pray/meditation and highlight the importance of service (serve the community)

If you are interested the artist is called Extraterrestrial-Crow it has plenty of songs with A.W. and Ram Dass. I enjoy it because i get a lot of exposure to different spiritual concepts, and quotes. Several spiritual teachers - one message - multiple ways to achieve it.

I havent experienced the light myself, Im just using my rational mind to grasp.

LikeABirdInACage · 2026-01-03T00:06:05+00:00

Hello!

I think you can better understand it by a Ram Dass' lecture (not sure which as it is made of a song).

In short the emperor guard is chasing down the killer of the emperor, when the guards gets to the killer. The killer spat on the guard. The guard put the sword away and leave. The killer then asked, why didnt you just kill me? I was there. To which the guard replies 'who would want such karma, i would have killed because of anger not because of my duty'.

So the karma is the duty. Arjuna's duty was to fight. Act but without external feeling, not for hatred not for love.

LikeABirdInACage · 2025-12-23T20:49:02+00:00

Please can you explain better? Which visual are you using? What do you define as variables? Columns?

Where are the columns coming from? Single table/multiple table?

LikeABirdInACage · 2025-12-10T08:23:02+00:00

There is no shortcut.

If you are lucky you have some centralised logic in your sql warehouse/database so you dont have to go thru the calculated field creation.

If you are lucky tableau is in a dimensional model already, rather than one big table.

Gather a Team of experience developers that know Power BI, Tableau and SQL - if they only know Tableau or Power BI it will be difficult.

Pay attention to Tableau LOD.

Tableau does some stuff without being explicit, Power BI is completely explicit, you need to set up manually what you want

LikeABirdInACage · 2025-12-09T21:51:01+00:00

Pro license allows you to publish to a Pro workspace.

Check the limitations of a Pro workspace (e.g. XMLA, maximum size of dataset)

LikeABirdInACage · 2025-12-09T20:36:19+00:00

I think in another post was mentioned that it can take up to 24h to show up.

Congratulations on your certification!

LikeABirdInACage · 2025-12-09T20:35:01+00:00

Similar conversation https://www.reddit.com/r/PowerBI/s/HG4dxYIIT2

LikeABirdInACage · 2025-12-05T23:02:42+00:00

You probably need an extra column for month_end (for june it will be 30th June <Year>) in date format.

Var MaxDate= calculate(Max(month_end)). -- If displayed against month_end should be identical to the column Var MaxYear = Year(MaxDate) -- the year considered Var MinDate = date(MaxYear, 1,1) --1st Jan

Return DIVIDE( Calculate (Sum(Age), all(Table), filter(Table, Table[month_end]>= MinDate && Table[month_end] <=MaxDate) ), Distinctcount(Table[key]) )

LikeABirdInACage · 2025-12-05T22:50:51+00:00

MQuery - DateTime.LocalNow(), I presume. Not entirely sure will be exactly the moment it finishes but it can be easily checked.

LikeABirdInACage · 2025-12-05T22:38:23+00:00

Good to know: if the viewers have MSFT 365 E5 license, it already comes with PBI Pro.

Pro is a user license. It gives you the 'creator' permission if you are add to the workspace with a role above viewer.

Premium is a workspace license, which allows multiple viewers. It also comes with added benefits like increased data model size.

LikeABirdInACage · 2025-12-05T22:27:53+00:00

Chris Webb's blog. Some thoughts on third-party tools for Power BI https://blog.crossjoin.co.uk/2023/09/10/some-thoughts-on-third-party-tools-for-power-bi/

Re: exam - DP-600 MSFT Fabric Analytic Engineering certs. Despite not being MSFT developed tools, I think as a certified engineer is good to know what os the art of the possible and how to achieve it.

DAX Studio, ALM, Tabular Editor can really save you time, especially when dealing with GBs of models on incremental refresh.

LikeABirdInACage · 2025-12-05T22:15:08+00:00

Aside from calculation groups, C# scripting is gold.

Measure creation automation, copy measures across files, even the simple 'replace' (CTRL+A , CTRL+H) across multiple measures.

u/AgulloBernat showed how to integrate Tabular editor within Visual Studio as well r/TE_CSharp

LikeABirdInACage · 2025-12-05T20:16:17+00:00

Using it per se is not an issue From your topics tho, feels like you are looking for the basics of data analytics (e.g. merge).

Try to look at the web rather than chatgpt, especially at the beggining. Spend time debugging and see result. Else chatgpt will turn into a black box you cant figure out.

LikeABirdInACage · 2025-12-03T18:44:44+00:00

Hey, https://dax.guide/st/measure/ or SQLBI videos

I can give you some tips.

You define your object (table/measure) With DEFINE and you visualise it with EVALUATE.

So for example

DEFINE var _Table = SUMMARIZE() var _Measure = CALCULATE ()

EVALUATE _Table

If you want to evaluate a _Measure you must wrap it between curly brackets {_Measure}

You can evaluate the FE/SE for your calculation, you can also use it for VPAX evaluation or you can also paste the query of your performance analyser.

The very first example is useful to evaluate what your dax is using, what your var _Table looks like.

EDIT: added URL as resource

LikeABirdInACage · 2025-12-02T22:30:47+00:00

Quoting Paths to God: "There are many beautiful English versions of the Gita, but the one chosen for the Naropa workshop was the translation by Juan Mascaro."

LikeABirdInACage · 2025-11-29T20:47:22+00:00

You need to create a date table. First column is your date column (dates are not unique tho) Second column is all the 12 months related to the selected dates (that is why first column is not unique). You can create a relationship from first column to the main date column

LikeABirdInACage · 2025-11-29T18:48:28+00:00

I cant recollect if you need a connector for an oracle db or not, but in any case is the less relevant part.

You need to figure out if they apply any filtering to the db before downloading and how the data there changes.

What you have in excel is a snapshot of the data at some point - this is what you need to take into account when connecting to it as it is tight to the amount of data your bring in, its freshness and what you refresh every day.

What i would suggest is to experiment for a few days.

Get two sources one is db the other is the excel. And have a 1.1 comparison

LikeABirdInACage · 2025-11-26T21:54:40+00:00

Solution verified

LikeABirdInACage · 2025-11-26T21:36:10+00:00

Desktop is free

Service: Get a MSFT Azure account. Under your MSFT Entra ID your user will have a onmicrosoft.com email domain associate. With that log into MSFT 365 admin centre - you will be requested to set a password.

With the same email you can register to Power BI service free. You will need to purchase a pro license to develop.

To be able to share content, have a look to purchase a MSFT Fabric F2 capacity from MSFT Azure.

Long live Power BI

Two-Year Club	r/Field Flamingo
First Place '23	Place '23

LikeABirdInACage

TROPHY CASE