cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
srlabhe123
Helper V
Helper V

DAX not working in Power BI connecting to Direct Query Tabular Model

Hi All,
I have Direct Query Tabular Model created, which I am connecting in Power Bi desktop through Connect Live.

When I does that I could pull objects in Table Visual , but if I pull measures created in Tabular Model it does not show data rather it changes whole table visual in blank.

But if I do not use any summarized data then it works fine, I have tried creating measures on PBI report level but that too pops up same issue.

If I convert the Tabular Model to in memory then everything works fine.

Do anyone know what could be the issue here with DAX created in DQ Tabular Model, the DAX i have created are simple like Sum(Qty), Count(Cust ID).

Appreciate help here.

 

Please find snapshots I could capture below:

ThanksError1.jpg

4 REPLIES 4
v-deddai1-msft
Community Support
Community Support

Hi @srlabhe123 ,

 

Are you trying to connect to ssas that have a direct query data source? Based on my test, it works well with dax

sum. Would you please try to update the desktop to the latest version and try again?

 

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

 

Best Regards,

Dedmon Dai

 

parry2k
Super User III
Super User III

@srlabhe123 whatever you are using to visualize the data is from the same table like measure and column in the table visual? Are there  more tables and relations?






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

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Yes the columns and measures are from same table , though there are other tables in relation.

any suggestions here please ?

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors