Forum Discussion
Power BI Export to excel - Keep data type
Hi all,
I found a work around to this,
I created a measure to output the quantities of that column and i am using it for analysis.
Thanks
Super UserIt seems like the issue you're encountering is related to the data type formatting when exporting data from Power BI Service to Excel. Here are a few steps you can take to resolve this issue:
1. **Check Data Types in Power BI:** First, ensure that the data types for the columns in your Power BI report are set correctly. If the columns storing numbers are formatted as text in Power BI, they might export as text to Excel.
2. **Format Columns in Power BI:** In Power BI Desktop, select the columns that are storing numbers but are formatted as text, and change their data type to "Decimal Number" or "Whole Number" as appropriate. You can do this by selecting the column, going to the Modeling tab, and choosing the desired data type from the "Data Type" dropdown menu.
3. **Refresh the Data Model:** After updating the data types in Power BI Desktop, refresh the data model to apply the changes. This ensures that the correct data types are used when exporting the data to Excel.
4. **Export to Excel:** Once the data types are corrected in Power BI Desktop, try exporting the data to Excel again using the "Export > Analyze in Excel" option. Check if the columns are now exported as numeric values instead of text.
5. **Format Cells in Excel:** If the columns still appear as text in Excel after exporting, you can manually format the cells in Excel to convert them to numeric values. Select the cells containing the numeric data, right-click, and choose "Format Cells." Then, choose the appropriate numeric format (e.g., Number, Currency) from the Number tab in the Format Cells dialog box.
By following these steps, you should be able to ensure that the numeric columns in your Power BI report are exported correctly to Excel and can be used in the value field of a PivotTable. If the issue persists, double-check the data types and formatting settings in both Power BI Desktop and Excel to identify any discrepancies.
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!
The columns in PowerBI are formated correctly as decimal numbers. The same columns i use to calculate total sales in PowerBI and as per my screen shot it shows the Sum symbol in PowerBI. Not fixed yet but thanks.