Analyze in Excel (Missing columns)

[zzakir]

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.

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.

Zak

[Greg_Deckler]

@zzakir - Include them in your visual?

[zzakir]

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.

[zzakir]

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

[v-easonf-msft]

Hi, @zzakir 

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

[zzakir]

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]

Hi , @zzakir 

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