Is there also a quick way to copy back measures you made in the PBIX file with the referenced Power BI dataset in it, to get them back into the pbix file with the datamodel? Otherwise you have to go back and forth between the 2 pbix files which slows down the development proces.
Hi Niels, good question. The goal of adding a measure in a thin report is usually because it doesn't make sense to keep it in the master model. If just this specific report requires it vs all the other reports connected to the dataset. If the goal from the start is to have the measure in the master model then it typically gets added there from the start. I guess it's a long way of saying there isn't any way to instantly transfer them between. Unless you opened both the PBIX of the thin report and the model and copy/paste the measure between them.
I used to be more protective, but it builds customer trust, especially when you build a shared dataset. Plus I've trained myself to a skill level that even if they can see the model, they won't necessarily understand all of it, and still need my expertise. :)
This makes the Measure Description property display as a tooltip to the developer when the report is open in Power BI. Can you please show how to achieve the same behaviour when the published report is run by a report user (NOT a developer)?
Thanks for sharing! This content is very great! But the data model I use is on Azure Analysis Services. Is there a "Advanced Script" like a Tabular Editor to write this scrip and add a description equal dax expression for all measures?
@@HavensConsulting Thanks for the quick feedback! I cannot connect the Tabular Editor to the AAS template. There is a problem with doing this that when you put it into production, if you don't amend the JSON as well, it doesn't load the measurements or changes made by the Tabular Editor. So I was wondering if there is an "Advanced Script" within Azure Analysis Services to change the description of all measures.
First wave models and BI were under lock and key. Having transparency with connected datasets builds a lot of trust with clients and users. I embrace open and sharing culture :)
![Formatting All [DAX] Measures at Once with Tabular Editor](http://i.ytimg.com/vi/oF0EbgKfEDY/mqdefault.jpg)
![Formatting All [DAX] Measures at Once with Tabular Editor](/img/tr.png)
Great Tip! How do you apply the same concept but for calculated columns?
foreach(var c in Model.AllColumns.OfType())
{
c.Description = c.Expression;
}
@@HavensConsulting Thank you for taking the time to reply! This is fantastic and will save me hours worth of work!
You also have Tabular Editor 3 installed ... 😜. Any hints on what's coming? :D
I wonder how many people knew about this. Thanks a lot for sharing this tricks!
Of course!
Thank you Reid for another awesome tip.
Thanks for watching!
where I could find the external tool?
Links in the description :)
Great tip mate, definitely time saving using Tab editor
Yeah...
Also could improve with Format.Dax(m.Expression) :D
Yup, I did a video on that right after this one. ua-cam.com/video/oF0EbgKfEDY/v-deo.html 😁
This is Dope! Thanks for sharing
Awesome... Thanks :)
Is there also a quick way to copy back measures you made in the PBIX file with the referenced Power BI dataset in it, to get them back into the pbix file with the datamodel? Otherwise you have to go back and forth between the 2 pbix files which slows down the development proces.
Hi Niels, good question. The goal of adding a measure in a thin report is usually because it doesn't make sense to keep it in the master model. If just this specific report requires it vs all the other reports connected to the dataset. If the goal from the start is to have the measure in the master model then it typically gets added there from the start. I guess it's a long way of saying there isn't any way to instantly transfer them between. Unless you opened both the PBIX of the thin report and the model and copy/paste the measure between them.
Neat trick, but most a lot of my measures are a paragraph long :-) Plus I don't like sharing my datasets :-[
I used to be more protective, but it builds customer trust, especially when you build a shared dataset. Plus I've trained myself to a skill level that even if they can see the model, they won't necessarily understand all of it, and still need my expertise. :)
This makes the Measure Description property display as a tooltip to the developer when the report is open in Power BI. Can you please show how to achieve the same behaviour when the published report is run by a report user (NOT a developer)?
Good question. Could you provide me an example of where you'd want this "displayed"?
such a cool trick :) thank you
Awesome trick!
Beautiful
AWESOME!
Excelent trick!!
great technique. Thank you very much
Absolutely!
Thanks for sharing! This content is very great!
But the data model I use is on Azure Analysis Services. Is there a "Advanced Script" like a Tabular Editor to write this scrip and add a description equal dax expression for all measures?
You should be able to connect to the AAS model with this tool as well, and run the same script?
@@HavensConsulting Thanks for the quick feedback!
I cannot connect the Tabular Editor to the AAS template. There is a problem with doing this that when you put it into production, if you don't amend the JSON as well, it doesn't load the measurements or changes made by the Tabular Editor.
So I was wondering if there is an "Advanced Script" within Azure Analysis Services to change the description of all measures.
@@thiagomoraes5584 that I unfortunately do not know. Darren Gosbell would be a great person to ask that (he created DAX studio)
Dataset open and connected report open is now past
First wave models and BI were under lock and key. Having transparency with connected datasets builds a lot of trust with clients and users. I embrace open and sharing culture :)
This is cool! Thank you so much
Glad you like it!
Wow this is amazing
Thank you!
fabulous 👏🏻👏🏻
Much appreciated :D
Awesome trick!!!
Thanks!
I spy with my little eye Tabular editor 3. Any good ? What does Business ops extension do also ?
Haha, thought I hid that completely. Lips are sealed until it comes out. All I can say is every version is better than the last!
@@HavensConsulting Still waiting! :)
@@HavensConsulting Still waiting! :)
@@mcnater it's in preview right now and Daniel is releasing it soon. Keep checking his blog. :)
@@HavensConsulting thanks sir...just signed up for the beta and checked out his blog as well. Appreciate this overview as always.
Awesome bro 😎
Thanks man
Nice Trick, thanks!
Another practical use could be using this to FormatDax(dax) all measures.
foreach (var m in Model.AllMeasures) {
m.Expression = FormatDax(m.Expression);
}
@@jorgeeduardomoltenimoreno3048 that's actually going to be my next video anyways! Automation in Tabular Editor is amazing ❤
@@HavensConsulting Great! Thanks