Macros in Power BI

[MariaFlorenciaB]

Hi everyone!

I am working with the free version of Power BI. Before publishing my dashboard and share it to the users, I have to hide each formula in order not to let the users download the cube in Excel.

I am taking about 40 formulas more or less and I have to hide them every month (long story!), I can't hide the table as total because you cant do that when the formula is being used in the dashboard.

Is there any possibliity to create a MACRO in Power BI to run it and hide formulas automatically?

thanks in advance!!!

[Anonymous]

Are these formulas measures?  Could you host the measures in a separate table and simply make the table "Hide in Report View"?

For each measure there is an option in the ribbon that lets you change the home table.  You can find that under the modeling tab.