Analyze in Excel (Missing columns)

Question

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 multiple dimension tables/lookup tables.My value measure (amount) sits in Fact Table.&nbsp;When I double click on the pivot in Excel to see the underlying data, I noticed that its missing all the columns that I have a relationship with to a lookup/dimension table. What do I need to do to get those columns show when a user double click on a amount in the pivot table in Analyze in Excel.&nbsp;Zak

greg_deckler · Answer

Anonymous&nbsp;- Include them in your visual?

anonymous · Answer

Its in Excel, did you mean pivot instead of Visual? I don't have a visual in Power BI Service, I clicked on Analyze in Excel from the database not the report.

Does it have anything to do with RLS? I don't have any RLS set up.

anonymous · Answer

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

v-easonf-msft · Answer

Hi,&nbsp;Anonymous&nbsp;
Do you mean that in the "show details" sheet, you miss&nbsp;the columns that you&nbsp;have a relationship with to a lookup/dimension table?
Please check&nbsp; if&nbsp; you can find the missing&nbsp; information&nbsp; in the header.

&nbsp;
If I misunderstand ,please kindly&nbsp;share related screenshots .
&nbsp;
Best Regards,Community Support Team _ Eason
&nbsp;

anonymous · Answer

Hello Eason,v-easonf-msft&nbsp;Thank you for the response!Please note my responses in highlight below:Do you mean that in the "show details" sheet, you miss&nbsp;the columns that you&nbsp;have a relationship with to a lookup/dimension table?Yes.Please check&nbsp; if&nbsp; you can find the missing&nbsp; information&nbsp; 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). &nbsp;How can I have the fields in headers show as a column?How can I show the data from my fact table that are not fields in pivot table and are not in the header?&nbsp;(These fields have&nbsp;a relationship with to a lookup/dimension table and do not show in header)&nbsp;

Forum Discussion

Analyze in Excel (Missing columns)

7 Replies

Related content

Inferring Missing Columns and Imputing Missing Data

Best Practice Analyzer

missing data

Total value missing in calculated column

missing data