topic Re: Missing Values in Developer

Missing Values

Anonymous — Tue, 04 Aug 2020 14:40:23 GMT

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"

Re: Missing Values

lbendlin — Tue, 04 Aug 2020 19:07:27 GMT

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".

Re: Missing Values

Greg_Deckler — Tue, 04 Aug 2020 20:56:51 GMT

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.

Re: Missing Values

Anonymous — Wed, 05 Aug 2020 00:27:18 GMT

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

Re: Missing Values

Anonymous — Fri, 07 Aug 2020 06:27:08 GMT

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