Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
SNik
Helper I
Helper I

How to add objects like Measures, DAX, ..... in a Power BI desktop file using PowerShell ?

Hi

Assuming i have Power BI desktop file (*.pbix) and lest assume i have the DimDate in it with data range of (From: 2000-01-01 ....To: 2050-01-01), i have the columns Year-Quarter-Month and many more..

 

I'd like to add a Hierarchy in the DimDate in PowerBI using Powershell or .NET code

 

something like

 

      H-Year                            <<--- this is the hierarchy name in Power BI

          Year                            <<--- This is the first level of the hierarchy

          Quarter                       <<--- This is the second level of the hierarchy

          Month                         <<--- This is the third level of the hierarchy

 

i don not want to do this manually , i need to automate this process, the reason is i have 100 measer and Hierarchy , columns that i need to create, so i prefer to do it dynamically using .NET or PowerShell

 

thanks

Nik

Sincerely
Nik- Shahriar Nikkhah
1 REPLY 1
v-yulgu-msft
Microsoft Employee
Microsoft Employee

Hi @SNik,

 

I'm afraid this is not achievable to create columns or measures via running PowerShell .NET code. Please submit this idea at this page, if this feature is mentioned by many users, PG will consider adding it to later release.

 

Best regards,
Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.