cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
srikanthnama Regular Visitor
Regular Visitor

SSAS Measures definition will not appear in Power BI


We are not able to see a definition entered for SSAS measure in Power BI(PBI) desktop. Table definition and other column definitions entered in SSAS will show up as expected in PBI desktop.

 

This is so inconvenient as we need to open SSAS (and tabular model) to find out what is the undelying DAX logic related to a measure. Having the logic or the DAX query itself as part of the measure definition (and shown in PBI) will help big time.

 

I am not sure whether the issue is at SSAS or PBI. But wanted to just indicate the issue and get your feedback.

2 ACCEPTED SOLUTIONS

Accepted Solutions
Moderator v-qiuyu-msft
Moderator

Re: SSAS Measures definition will not appear in Power BI

Hi @srikanthnama,

 

Please open the tabular project in SSDT, then click Process All like below, then deploy the model. 

 

q4.PNG

 

In Power BI desktop version 2.59.5135.781 64-bit (June 2018), get data from this SSAS tabular, check if the measure description is displayed now. 

 

Best Regards,
Qiuyun Yu 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
srikanthnama Regular Visitor
Regular Visitor

Re: SSAS Measures definition will not appear in Power BI

I have to aplogise for my previous comment. It worked after i added the definitin to the measure and THEN did Process All. Thanks for clarifying this and the quick response.

6 REPLIES 6
Moderator v-qiuyu-msft
Moderator

Re: SSAS Measures definition will not appear in Power BI

Hi @srikanthnama,

 

I have reported this issue internally: CRI 74641272. Will update here once I get any information. 

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Vicky_Song Established Member
Established Member

Re: SSAS Measures definition will not appear in Power BI - Status changed to: Accepted

 
Moderator v-qiuyu-msft
Moderator

Re: SSAS Measures definition will not appear in Power BI

Hi @srikanthnama,

 

Please open the tabular project in SSDT, then click Process All like below, then deploy the model. 

 

q4.PNG

 

In Power BI desktop version 2.59.5135.781 64-bit (June 2018), get data from this SSAS tabular, check if the measure description is displayed now. 

 

Best Regards,
Qiuyun Yu 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
srikanthnama Regular Visitor
Regular Visitor

Re: SSAS Measures definition will not appear in Power BI

Hi Qiuyun, We always do the Process All and then deploy the tab model. What has changed since I posted this question ? I dont see any difference. Were you able to see the Measure description in Power BI Desktop ? If yes, appreciate if you can share some screen shots.

 

Thanks,

Srikanth

srikanthnama Regular Visitor
Regular Visitor

Re: SSAS Measures definition will not appear in Power BI

I have to aplogise for my previous comment. It worked after i added the definitin to the measure and THEN did Process All. Thanks for clarifying this and the quick response.

Moderator v-qiuyu-msft
Moderator

Re: SSAS Measures definition will not appear in Power BI

Hi @srikanthnama,

 

Thanks for your update. Smiley Happy

 

As the issue is resolved now, I will close this thread. 

 

Best Regards,
Qiuyun Yu 

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