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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
KellyPorter
Frequent Visitor

New measure in SSAS does appear in pbix but does not appear in service, using live connection

I have added a column and some measures to a SSAS Tabular database.  The PBIX that points to SSAS uses a live connection and it does show the new column and measures and I am able to add them to visualizations.  But when I publish the PBIX to the service, the visuals throw error "Something's wrong with one or more fields" and "Fields that need to be fixed.  Something's wrong with one or more fields..... Please try again later or contact support."

 

I have tried pointing the PBIX to another database and then back again.  I have tried publishing to a different workspace, which worked the first time but when I tried to publish again and replace that dataset it started erroring out, too.   I have tried stopping and starting Analysis Services. I have tried restarting the enterprise gateway.  

 

How do I get the service to recognize the new column and measures?  I don't understand how this is happening when I can see it correctly in the PBIX.  Does anyone have any ideas?

1 REPLY 1
v-yuta-msft
Community Support
Community Support

@KellyPorter ,

 

I would suggest you to use fiddler to catch the trace in power bi service when this issue occurs. And then contact the support center by creating a support ticket here.

 

Community Support Team _ Jimmy Tao

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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors