Forum Discussion

antoniofallucca's avatar
antoniofallucca
Helper I
8 years ago
Solved

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.   Howe...
Need Help
  • antoniofallucca's avatar
    antoniofallucca
    8 years ago

    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

v-caliao-msft's avatar
v-caliao-msft
Microsoft Employee
8 years ago

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's avatar
antoniofallucca
Helper I
8 years ago

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

  • v-caliao-msft's avatar
    v-caliao-msft
    Microsoft Employee
    8 years ago

    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's avatar
      antoniofallucca
      Helper I
      8 years ago

      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