Forum Discussion
Export data to Excel
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.
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.