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

direct query card

I first built a cube in Power BI desktop and used a card to return a text example "Last Name, First Name Middle Name" it worked fine with the data imported as there was a First Value option.

 

However, when I built a cube and use a direct query the card option for First was no longer there, the only option was count and distinct count.  Is there a reason for this or did I do something wrong?

 

Is there a work around as now I'm using a table to extract the value do I need a measure instead help?

1 ACCEPTED SOLUTION

Accepted Solutions
antoniofallucca Regular Visitor
Regular Visitor

Re: direct query card

@v-caliao-msft

 

Thank you that is not an option for now I'm trying to showcase this to our company so that we can move forward with Power BI.

 

I've got a work around, I'm using a table with style none, column hearders same color as the background, so It appears that works.

 

It's not as nice as a card but still it will work until Microsoft gets around to fixing it.

 

Thank you,

 

Antonio

7 REPLIES 7
Moderator v-caliao-msft
Moderator

Re: direct query card

@antoniofallucca,

 

For a card visual, it will aggregate your column values automatically. For text value, the default aggregate function is FIRST.
Capture.PNG

 

If you want to show all values in your dataset, you could use table visual. 

 

Regards,

Charlie Liao

antoniofallucca Regular Visitor
Regular Visitor

Re: direct query card

Capture.PNG

 

As you can see I don't have that option I believe that it is because I'm using direct query and I'm not importing the data.  We have a very powerful server and this is how our company wants us to do it.

 

Is there anything else you can think of?

 

Thanks,

 

Antonio

antoniofallucca Regular Visitor
Regular Visitor

Re: direct query card

@v-caliao-msft

 

Please look at my example what am I doing wrong?

 
Moderator v-caliao-msft
Moderator

Re: direct query card

@antoniofallucca,

 

I have tested it on my local environment, we can reproduce this issue. It seems this is the default setting for multidimensional database by using directquery mode.

 

Regards,

Charlie Liao

antoniofallucca Regular Visitor
Regular Visitor

Re: direct query card

@v-caliao-msft

 

So this is the default setting issue in SSAS, what setting do I change to correct the issue?

 

Thank you,

 

Antonio Fallucca

Moderator v-caliao-msft
Moderator

Re: direct query card

@antoniofallucca,

 

Based on my research, I am afraid there is no such an option to allow us to show first or last value in this mode.  To work around this issue, you could change directquery to import mode.

 

Thank you for your understanding.

 

Regards,

Charlie Liao

antoniofallucca Regular Visitor
Regular Visitor

Re: direct query card

@v-caliao-msft

 

Thank you that is not an option for now I'm trying to showcase this to our company so that we can move forward with Power BI.

 

I've got a work around, I'm using a table with style none, column hearders same color as the background, so It appears that works.

 

It's not as nice as a card but still it will work until Microsoft gets around to fixing it.

 

Thank you,

 

Antonio