Forum Discussion
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...
Hello 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
Community Support
Community SupportHi , 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