![]() ![]() ![]() But, as soon as I refreshed the data source from Power Query all of the defined formatting were gone. So I loaded the data to an Excel worksheet and I spent some time to do some cell formatting including thousand separation and currency formatting and so on. So I decided to do use the power of cell formatting in Excel. I was loading sales data from SQL Server and I noticed that there is no easy way to define a 1000 separator in Power Query. In this post I want to share my experience with refreshing data in Power Query and the way it affects loaded data to an Excel worksheet. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
May 2023
Categories |