Data not pulling in

[gbarr12345]

Hi,

I have a Power BI report that I pulled the data in using Excel.

However some of the data doesn't seem to have pulled in. Please see below:

I know that the depletion volume should be there as there's numbers in the Excel.

Any idea why power BI didn't pull it in?

[Ritaf1983 · Accepted solution]

Hi @gbarr12345 

here are some common reasons why numbers from Excel might not import correctly into Power BI:

1. Data Type Mismatch: Ensure that the columns in Excel are formatted as numbers. If the column is formatted as text, Power BI might not recognize the values as numbers.

2. Formulas in Excel: If the cells contain formulas, ensure that the results of these formulas are numeric. Sometimes, the results might be text or errors which Power BI can't interpret as numbers.

3. Hidden Characters: Sometimes, hidden characters like spaces or non-printable characters in Excel cells can cause issues. Use the TRIM function in Excel to remove any extra spaces.

4. Regional Settings: Check the regional settings in both Excel and Power BI. Different regional settings might use different decimal and thousand separators.

5. Column Headers: Ensure that the column headers in Excel are correctly named and do not contain any special characters that might confuse Power BI.

To diagnose the issue, you can:

1. Check Data Types: Verify the data types in Excel and ensure they match the expected types in Power BI.

2. Inspect Formulas: Check if any cells with formulas are causing errors or returning non-numeric results.

3. Use Power Query: In Power BI, use Power Query to inspect the data being imported. You can use it to clean and transform the data before loading it into your model.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[gbarr12345]

Hi Rita,

This is fixed now. Thank you so much for your help!!

[Ritaf1983]

Happy to help 🙂