Missing Values

[Anonymous]

let
    Source = Excel.Workbook(Web.Contents("sharepoint folder"), null, true),
    Budget_Strategies_Total_Table = Source{[Item="Budget_BU_Total",Kind="Table"]}[Data],
    #"Changed Type" = Table.TransformColumnTypes(Budget_Strategies_Total_Table,{{"Budget (manual entry)", type number}}),
    #"Filtered Rows" = Table.SelectRows(#"Changed Type", each ([Business Unit] <> "Total")),
    #"Changed Type1" = Table.TransformColumnTypes(#"Filtered Rows",{{"%", type number}, {"20%", type number}, {"-20%", type number}, {"2020 P1 P&L Target", type number}, {"2020 P1 P&L Upper", type number}, {"2020 P1 P&L Lower", type number}, {"2020 P1 Integration Target", type number}, {"2020 P1 Cash Target", type number}, {"2020 P1 Cash Upper", type number}})
in

I am still missing the values in {"2020 P1 Integration Target" and it shows the value in the excel sourve folder. Please advice on what to do thanks.
    #"Changed Type1"

[Anonymous]

Hi @Anonymous,

I'd like to suggest you navigate back your query table steps to previous steps and check their contents to confirm if that field's value loading correctly.

If they loading correctly, please double-check the query steps after the current state and does the structure transform and shape if they affect the results.

For other scenarios, you can check the raw workbook to confirm how that fields calculate/design and try to fix it as static values instead of formula.
Regards,

Xiaoxin Sheng

[Greg_Deckler]

Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

[lbendlin]

Are you referring to missing values in a column, or to a missing sheet?  Your data source exclusively pulls the content of the table defined as "Budget_BU_Total".

[Anonymous]

I am talking about the missing value in the "2020 P1 Integration Target" Column.