Forum Discussion

Seve's avatar
Seve
Regular Visitor
4 years ago

Data loss between file source and Power Query

Hello community, I encounter a technical issue with data which have disappeared between the file source (xlsx) and the preview in Power Query… it concerns 4 items in text format. I confirm that data...
Data Protection
HotChilli's avatar
HotChilli
Community Champion
4 years ago

Are these query steps auto-generated by powerbi? Are you using similar excel files in a folder as a source?

--

Can you try loading the single file into a new pbix using 'Excel workbook' as source to test?

--

I think I would need to look at the original excel sheet and trace it through the query steps to investigate further.  If you can put that and the pbix on a 3rd party site and link here, I'm sure myself or edhans can help you.

Seve's avatar
Seve
Regular Visitor
4 years ago

Hello Hotchilli,

Thank you very for your idea. I confirm that the applied steps are automatically generated by the system progressively when I transform data. I uploaded the Excel source file via Excel wookbook directly from my personal directory of files and like that it worked effectively:  none data loss.  I join the corresponding scrennshot. I will try to send you the Excel file with the pbix.

  • KT_Bsmart2gethe's avatar
    KT_Bsmart2gethe
    Impactful Individual
    4 years ago

    Hi Seve,

     

    There are usually data format such as " " that won't be considered empty. 

     

    Regards

    KT