Forum Discussion

nirvana_moksh's avatar
nirvana_moksh
Icon for Impactful Individual rankImpactful Individual
7 years ago

Export to Excel (Summarized Data) Showing different results

Hello All,   I have a data table visualization which has these two columns of totals - Total 1 and Total 2. Total 1 for instance on PBI Desktop and Service shows a  total of 1MM and column of Total...
Need Help
Show and Tell
v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi nirvana_moksh 

Do you add any filter over this table visual?

If you have applied filters to the visualization, the exported data will export as filtered.

 

Are these two columns from the same table or two different table?

 

Please pay attention to the limitations:

In Power BI Desktop, you'll only have the option for Summarized data. 

The data would be exported to a .csv file.

Once saved, you could open the .csv file in Excel.

The maximum number of rows that can be exported from Power BI Desktop and Power BI service to .csv is 30,000.

When using DirectQuery, the maximum amount of data that can be exported is 16 MB. 

 

Best Regards

Maggie

 

nirvana_moksh's avatar
nirvana_moksh
Icon for Impactful Individual rankImpactful Individual
7 years ago

v-juanli-msft  - So I found the reason why there is a difference in the sum's when exporting - when I remove the columns coming from another table the sum's match with what PBI shows. Is this normal behavior though?