Table column widths not retained after refreshing Power Query

[jiajia97]

Hi,

I have problem of my table column widths not retained after refreshing Power Query. Anyone can help on this matter?

 

[rahulshewale1]

Hi @jiajia97 ,

Right Click Power Query Table > Table > External Data Properties > Uncheck Adjust Column Width

Regard
Rahul Shewale

 

[jiajia97]

Hi,

I had inserted a conditional formatting in one column. However, when I refresh the data, I have faced another problem. Can you assist me on solving these issues too?

Thank you!

 

[rahulshewale1]

HI,

Please upload file.

Regard
Rahul shewale

 

[jiajia97]

HI,

Please upload file.

Regard
Rahul shewale

Hi, is it possible if I wish to personal message you ?

 

[rahulshewale1]

Hii,

Please share dummy data with desire output,


Regard
Rahul Shewale

 

[GraH - Guido]

You are simply loading to many rows it seems. Do you really need/want all that data (1.04 Mio records) to land in Excel? If you want to do some further analysis you better consider loading the data as connection only and preferably connect it to the data model or even a standard pivot.
Summarize the data with pivots. Then apply CF or whatever. Making your solution "lighter".