cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
StevenVF
Frequent Visitor

Datamart - Can't create new measures

Hi All

 

I have a datamart that considering is a preview feature was working very well, in the last few days however i can no longer add new measures, when i try after it thinks for a while i get the following:

StevenVF_0-1669924525905.png

 

I have another test datamart that creating new measure works fine in.

Anyone have any ideas on how i can fix this?

1 ACCEPTED SOLUTION

Hi Aniya

Thanks again for the reply.

I was unaware you could raise a ticket for a preview feature, that's good to know thanks.

I tried again this morning and magically my create measure is working again! I guess that's just preview feature shannaigans :).

 

Cheers.

View solution in original post

7 REPLIES 7
v-yueyunzh-msft
Community Support
Community Support

Hi , @StevenVF 

To create a measure(a measure is a collection of standardized metrics) select the table in the Table Explorer and select the New Measure button in the ribbon, as shown in the following image.

vyueyunzhmsft_0-1669947327441.png

If you can create a measure in a test datamart but not in a production datamart, can you be sure that your test workspace and production workspace are from the same capacity? If so, you can also expand on the current error details and provide it at your convenience, because as far as I know this is indeed a preview function, and there are some bugs at the moment. Thank you for your understanding and support!

 

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Appreacite the reply.

 

I was successfully creating measures in this datamart for some time, it's only become a problem in the last few days.

 

I have another test datamart in a different workspace and i tried there as well, it works fine in that datamart. Both datamarts are on the same premium capacity so i am at a loss as to why it's different for each for not apparent reason. The only error i get is what i originally posted.

Hi , @StevenVF 

Oh... Thank you for your quick response.You said it works last few days, but now you can not do it and return the error code.

In my test side , i always works when i create a measure in datamart.

 

If you are a Power BI Pro licensee, you can create a support ticket for free and a dedicated Microsoft engineer will come to solve the problem for you.

It would be great if you continue to share in this issue to help others with similar problems after you know the root cause or solution.

The link of Power BI Support: https://powerbi.microsoft.com/en-us/support/

For how to create a support ticket, please refer to https://community.powerbi.com/t5/Community-Blog/How-to-create-a-support-ticket-in-Power-BI/ba-p/6830...

 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

 

 

Hi Aniya

Thanks again for the reply.

I was unaware you could raise a ticket for a preview feature, that's good to know thanks.

I tried again this morning and magically my create measure is working again! I guess that's just preview feature shannaigans :).

 

Cheers.

GilbertQ
Super User
Super User

Yeah I agree it is awesome, just at times need to be patient in order to get more functionality working.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

GilbertQ
Super User
Super User

Hi @StevenVF 

 

I am not sure how to fix this. As it is a preview feature I suggest to people to play with it but to not use it for production workloads.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Thanks for the reply

 

Yes, totally understand that, however this is one of the main features of the preview, being able to create a model and associated measures in the serivce, otherwise this is just a dataflow. Be great to know when microsoft are going to move forward with datamarts, the idea is fantastic and it's been in preview for a long time now.

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.

Top Solution Authors
Top Kudoed Authors