Forum Discussion
Analyze in Excel (Missing columns)
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.
Has anyone experienced this issue before? Need help from someone who had uses or have used Analyze in Excel feature?
- v-easonf-msft
Community Support
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 _ EasonHello Eason,
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).
- 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?
(These fields have a relationship with to a lookup/dimension table and do not show in header)
- v-easonf-msft
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
