Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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...
Need Help
  • rubayatyasmin's avatar
    rubayatyasmin
    3 years ago

    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.

     

     

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

I did what you said but I am getting error.

rubayatyasmin's avatar
rubayatyasmin
Community Champion
3 years ago

Sorry, this is not English. I can not read it. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    rubayatyasmin 
    "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."

    I marked the place you mentioned here. but still i am getting error.