Forum Discussion
Excel Data missing when there is a formula in the source.
Blank for all values that had the round function applied, my issue is that these rounding functions are generated in the source, and PQ doesn't recognize the values unless I open the source file, select all, and paste values. I'd like to avoid that step to get to my next level of automation (hands off refresh to generate the clean table)
Hi Anonymous ,
If possible, try saving the Excel file as a CSV file before loading it into Power Query. CSV files contain only values and not formulas, so this may help Power Query recognize your data.
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum