Forum Discussion
Pivot table in power query
hello, there is a help to make the Pivot table in the picture in a power query. Picture of the table below. It will make the job much easier and simpler in a situation like the first pictur...
ThisWorkbook.Connections("Combined_Financials_Sector").Refresh
note that Background refresh option should be checked. In the Excel UI, you can access this setting by clicking on "Connections" in the "Data" ribbon, selecting a connection, and clicking on "Properties". The "Enable background refresh" setting is in the dialog box that opens.
Hi, Anonymous
this is what I could achieve in PQ
though not an exact pivot table like Excel. You could use Power BI matrix visual as an alternative to the Excels pivot table.
It's far from the result I want. I am already using the result you showed. thanks