Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Analyze in Excel (Missing columns)

Hello, I created a star schema and uploaded it to Power Bi services. I then downloaded the data using "Analyze in Excel". I have a measure in my fact table which has one-to-many relationship with mu...
Dataflow
General Comment
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Has anyone experienced this issue before? Need help from someone who had uses or have used Analyze in Excel feature?

v-easonf-msft's avatar
v-easonf-msft
Community Support
6 years ago

Hi, Anonymous 

Do you mean that in the "show details" sheet, you miss the columns that you have a relationship with to a lookup/dimension table?

Please check  if  you can find the missing  information  in the header.

 

If I misunderstand ,please kindly share related screenshots .

 

Best Regards,
Community Support Team _ Eason

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hello Eason,

    v-easonf-msft 

    Thank you for the response!

    Please note my responses in highlight below:

    Do you mean that in the "show details" sheet, you miss the columns that you have a relationship with to a lookup/dimension table?

    Yes.

    Please check  if  you can find the missing  information  in the header.

    Yes! most of them are in header if I add them in the Pivot table as field. The ones that I didn't add as a field in pivot table are not in the header (but are in my Fact Table data).

     

    1. How can I have the fields in headers show as a column?
    2. How can I show the data from my fact table that are not fields in pivot table and are not in the header? 
      (These fields have a relationship with to a lookup/dimension table and do not show in header)

     

    • v-easonf-msft's avatar
      v-easonf-msft
      Community Support
      5 years ago

      Hi , Anonymous 

      Sorry, I’m afraid this is the case for most people. 

      No relevant threads or workarounds have been found currently.

      I would suggest you create a ticket to raise your problem to MS support team for better advice.

       

      Best Regards,
      Community Support Team _ Eason

    • makshata96's avatar
      makshata96
      Regular Visitor
      8 months ago

      Did you find the answer of your question becuse i am also facing the same issue.
      I created a star schema and uploaded it to Power Bi services. then downloaded the data using "Analyze in Excel". 
      When I double click a value in the Excel Pivot Table (from Analyze in Excel), the underlying data does not show. I want to know what settings or changes are required in Power BI so that users can see the detailed underlying data when they double click an amount in the pivot table.