Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
MH81003
Frequent Visitor

Issue with Values returning 0

Hello, I have an issue with my Power BI report that I can't a solution to. All of the data is being pulled successfully into the Power Query Editor except 1 column. This column is set as a decimal type but is showing 0 for all of the values that aren't null. This report is pulled from an Excel sheet that has the correct decimals. I am not sure why it's showing 0 for all of the values and have tried changing the type and decimal rounding. Please help!

1 ACCEPTED SOLUTION
123abc
Community Champion
Community Champion

It seems like you're encountering an issue with a specific column in your Power BI report where all the values, except for nulls, are showing as 0 despite the correct values being present in your Excel sheet. Here are some steps you can take to troubleshoot and potentially resolve this issue:

  1. Data Type Check: Make sure the data type of the column in Power Query Editor matches the data type of the column in your Excel sheet. If it's set as a decimal type in Excel, it should also be set as a decimal type in Power Query Editor.

  2. Data Transformation: Check if any data transformation steps in Power Query Editor might be causing the issue. There might be a transformation step (e.g., rounding, formatting) that is causing the values to become 0. Review the applied steps in the Query Editor and modify or remove any transformations that could be affecting the column in question.

  3. Data Preview: In Power Query Editor, use the "Data Preview" feature to examine the data before and after each transformation step. This can help you pinpoint where the values are changing to 0.

  4. Data Source Connection: Ensure that your Power BI report is connected to the correct Excel file and worksheet. Sometimes, if you have multiple Excel files or sheets with similar names, it's possible to connect to the wrong data source accidentally.

  5. Data Refresh: If you've made changes to the Excel sheet and want to reflect those changes in Power BI, make sure to refresh the data in Power BI. Data may not update automatically if the report is not set to refresh on a schedule or if you're viewing a cached version.

  6. Formula Evaluation: If there are calculated columns or measures that involve this specific column, review the formulas to ensure there are no errors or unintended transformations that might be causing the issue.

  7. Check for Errors: Look for any error messages or warnings in the Power Query Editor or in the Power BI report. These can often provide clues about what might be going wrong.

  8. Data Quality: Double-check the data quality in your Excel sheet. There might be issues with the data itself, such as formatting inconsistencies or unexpected characters, that are causing problems when it's imported into Power BI.

  9. Column Renaming: Ensure that the column name in Power Query Editor matches the column name in Excel exactly. Sometimes, a slight difference in column names can lead to issues.

  10. Reimport Data: If none of the above steps work, you can try reimporting the data from Excel into Power BI. This can sometimes resolve issues related to data import and transformations.

If you've gone through these steps and the issue still persists, please provide more specific details about the column and any transformations applied in Power Query Editor, and I'll do my best to offer further assistance.

View solution in original post

2 REPLIES 2
123abc
Community Champion
Community Champion

It seems like you're encountering an issue with a specific column in your Power BI report where all the values, except for nulls, are showing as 0 despite the correct values being present in your Excel sheet. Here are some steps you can take to troubleshoot and potentially resolve this issue:

  1. Data Type Check: Make sure the data type of the column in Power Query Editor matches the data type of the column in your Excel sheet. If it's set as a decimal type in Excel, it should also be set as a decimal type in Power Query Editor.

  2. Data Transformation: Check if any data transformation steps in Power Query Editor might be causing the issue. There might be a transformation step (e.g., rounding, formatting) that is causing the values to become 0. Review the applied steps in the Query Editor and modify or remove any transformations that could be affecting the column in question.

  3. Data Preview: In Power Query Editor, use the "Data Preview" feature to examine the data before and after each transformation step. This can help you pinpoint where the values are changing to 0.

  4. Data Source Connection: Ensure that your Power BI report is connected to the correct Excel file and worksheet. Sometimes, if you have multiple Excel files or sheets with similar names, it's possible to connect to the wrong data source accidentally.

  5. Data Refresh: If you've made changes to the Excel sheet and want to reflect those changes in Power BI, make sure to refresh the data in Power BI. Data may not update automatically if the report is not set to refresh on a schedule or if you're viewing a cached version.

  6. Formula Evaluation: If there are calculated columns or measures that involve this specific column, review the formulas to ensure there are no errors or unintended transformations that might be causing the issue.

  7. Check for Errors: Look for any error messages or warnings in the Power Query Editor or in the Power BI report. These can often provide clues about what might be going wrong.

  8. Data Quality: Double-check the data quality in your Excel sheet. There might be issues with the data itself, such as formatting inconsistencies or unexpected characters, that are causing problems when it's imported into Power BI.

  9. Column Renaming: Ensure that the column name in Power Query Editor matches the column name in Excel exactly. Sometimes, a slight difference in column names can lead to issues.

  10. Reimport Data: If none of the above steps work, you can try reimporting the data from Excel into Power BI. This can sometimes resolve issues related to data import and transformations.

If you've gone through these steps and the issue still persists, please provide more specific details about the column and any transformations applied in Power Query Editor, and I'll do my best to offer further assistance.

Thank you! One of the applied steps was messing with the data.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors