Forum Discussion

akhatri's avatar
akhatri
Icon for Helper I rankHelper I
4 years ago
Solved

Data Refresh Error

Hi all,   For the last week I have been getting the below error when trying to refresh data online.   When I refresh the data in the Desktop environment it all works perfect.   Please help.... ...
Need Help
  • akhatri's avatar
    akhatri
    4 years ago

    Found the issue, turns out one the steps in Power Query where I was appending one table to another was the reason it was throwing this error up. Very strange.

vanessafvg's avatar
vanessafvg
Icon for Community Champion rankCommunity Champion
4 years ago

If it is working in the deskop, would it however still be useful to go into power query and refresh all previews of the tables an check if there is an issue? 

akhatri's avatar
akhatri
Icon for Helper I rankHelper I
4 years ago

I ran a refresh in Desktop and it ran fine so im bit confused why its not refreshing online.

  • vanessafvg's avatar
    vanessafvg
    Icon for Community Champion rankCommunity Champion
    4 years ago

    not not a refresh in the visual pane, go into power query assuming this is an imported model, where you do the transformations and refresh the preview of all the tables.  

    • akhatri's avatar
      akhatri
      Icon for Helper I rankHelper I
      4 years ago

      I just tested and all tables are refreshing (Refresh Preview) fine in Power Query