Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |