Forum Discussion

_AlexandreRM_'s avatar
_AlexandreRM_
Helper II
3 years ago

Featured table in Excel doesn't match

Hello, I have 1 question about featured tables from PowerBI in Excel.

Excel: Version 2303 Build 16.0.16227.20202

PowerBI service isn't a premium capacity

 

Excel doesn't find any correspondance between PowerBI and the cell text:

I was able to attribute the data type to my cell but it appears with a '?':

 

While the reference does exist in PowerBI:

 

Here are my featured table settings:

 

 

I really don't understand, as I tried that a few month ago and it was working just fine. Is there something I'm doing in the wrong way?

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi _AlexandreRM_ ,

    I'm a little confused about your needs, Could you please explain them further? 

    Thanks for your efforts & time in advance.

     

    Best regards,
    Community Support Team_Binbin Yu

    • _AlexandreRM_'s avatar
      _AlexandreRM_
      Helper II
      3 years ago

      Hi Anonymous , my problem is that the proposed table in Excel doesn't find the key I defined in PowerBI.

       

      Here is the view in PowerBI, as you can see in my key column "Clé" I have the item "008083":

       

      But in Excel, when I try to retrieve data from this key, I get a question mark:

       

      The PowerBI dashboard is hosted on a premium capacity (I tried both on normal and premium).

      In don't understand why it's not working...