Missing Data After Refresh

[Anonymous]

Hi there,

I have updated my existing Excel data (in CSV) which is used as the data source for my PowerBI reports (I have not added any additional columns). When I've clicked Refesh via Home > Queries, the data does not come through and is missing within the colulms:

Please can you advise how I can pull the data through?

Thanks

[v-eachen-msft]

Hi @Anonymous ,

You could create a new csv file by copying data from the original file. Then try this csv file and check if it works.

[Jimmy801]

Hello @Anonymous 

if the query is referencing the right CSV-file, there should be no reason do don't load all rows. Maybe there was an issue about saving the file as CSV, as Excel is always asking you if you really want to save it as CSV, etc. You could also try to post the query here.

If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy

[Fowmy]

@Anonymous 

First, check your source data and make sure the data is there with the right format as per CSV

Go to the advanced editor of the query and copy the codes and paste here so we can check.

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon on the right if you like this reply 🙂

YouTube, LinkedIn

[Anonymous]

Hi @Fowmy,

This is the code:

let
    Source = Csv.Document(File.Contents("N:\HR\Reports\Headcount\Turnover\PowerBI\Harriet\PowerBI Spreadsheet\Leavers_N8.csv"),[Delimiter=",", Columns=7, Encoding=65001, QuoteStyle=QuoteStyle.None]),
    #"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]),
    #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Final Day of Employment", type date}, {"LocationID", Int64.Type}, {"Company Sub ID", Int64.Type}, {"Employee Id", type text}, {"Department ID", Int64.Type}, {"Gender", type text}, {"Reason for Leaving", type text}}),
    #"Added Conditional Column" = Table.AddColumn(#"Changed Type", "Custom", each if [Reason for Leaving] = "Death in Service" then "Voluntary" else if [Reason for Leaving] = "Didn't pass probation" then "Involuntary" else if [Reason for Leaving] = "Dismissed" then "Involuntary" else if [Reason for Leaving] = "End of Contract" then "Voluntary" else if [Reason for Leaving] = "Gave notice via compromise agreement" then "Involuntary" else if [Reason for Leaving] = "Redundancy" then "Involuntary" else if [Reason for Leaving] = "Resigned" then "Voluntary" else if [Reason for Leaving] = "Retiring" then "Voluntary" else if [Reason for Leaving] = "Terminated by Employer" then "Involuntary" else "Active"),
    #"Renamed Columns" = Table.RenameColumns(#"Added Conditional Column",{{"Custom", "Voluntary/Involuntary"}})
in
    #"Renamed Columns"

[Fowmy]

@Anonymous 

The query looks fine, you need to check your data and the layout. If possible share your CSV with a limited amount of rows.

You save in cloud drive and share the link here.

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon on the right if you like this reply 🙂

YouTube, LinkedIn