Forum Discussion
Export data to Excel
Data displayed in PowerBI are correct, and I would like to export them to Excel but there are differences in exported data in .csv file in Excel compared to data from PowerBI. Excel recognizes data as a E to the power of 15. How can I fix that?
PowerBI data
Data exported to Excel
Thanks in advance!!
When you try to export the data from PowerBI, try to choose the adequate file format that supports large numbers like in your case to make sure that it is maintaining their precision, such as Excel (.xlsx) or CSV UTF-8 (Comma delimited) (*.csv).
If you exported the data to a .csv file and you are experiencing the same issue when checking with Excel, try opening the file using the Text Import Wizard in Excel >select "Delimited" and choose the appropriate delimiter for your data (e.g., comma, tab) >select the column(s) containing the large numbers and choose "Text" as the data format.
Otherwise, select the column(s) containing the large numbers, right-click and choose "Format Cells". > "Number" as the category and choose the desired number format (e.g., "General" or "Number"). This should display the full number instead of scientific notation.
3 Replies
When you try to export the data from PowerBI, try to choose the adequate file format that supports large numbers like in your case to make sure that it is maintaining their precision, such as Excel (.xlsx) or CSV UTF-8 (Comma delimited) (*.csv).
If you exported the data to a .csv file and you are experiencing the same issue when checking with Excel, try opening the file using the Text Import Wizard in Excel >select "Delimited" and choose the appropriate delimiter for your data (e.g., comma, tab) >select the column(s) containing the large numbers and choose "Text" as the data format.
Otherwise, select the column(s) containing the large numbers, right-click and choose "Format Cells". > "Number" as the category and choose the desired number format (e.g., "General" or "Number"). This should display the full number instead of scientific notation.
Thank you AmiraBedh, that worked. But this would mean selecting each column and coverting them to text. Is there a better solution to it? Maybe choosing different data type in PowerBI, or is it even possible to limit the decimals?
You can proceed with the 3rd point (on Power BI):
Anonymous wrote:
Thank you AmiraBedh, that worked. But this would mean selecting each column and coverting them to text. Is there a better solution to it? Maybe choosing different data type in PowerBI, or is it even possible to limit the decimals?