Forum Discussion

rbrownson's avatar
rbrownson
Regular Visitor
9 years ago

Scheduled Refresh and Refresh Now giving Error

I scheduled a Refresh and it did not work. I tried to do a "Refresh Now" and it gave me the following error. My connections are connected and I am "online" with my data set.    There was an error w...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
9 years ago

If this worked previously, this is generally an intermittent issue and will get resolved.

rbrownson's avatar
rbrownson
Regular Visitor
9 years ago

It has not worked at all. The data has not refreshed on my online version of the report nor the published report. I even try to manually do it and it does not refresh. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Download a copy of your PBIX file and test inside the "Edit Queries" section.  You might not be deleting those rows as well as you think.  This will also let you set up the Power Query to remove them for you, thus removing any requirement to do this manually.

    • rbrownson's avatar
      rbrownson
      Regular Visitor
      9 years ago

      When I work in the Desktop version, every morning I refresh all my data manually (each file and table I right click and click "refresh data"), then I go into the queries and go into every file and click "Remove blank rows" and Remove duplicate rows, I hit clsoe and apply. Then I click the refresh button at the top which refreshes all tables and files. So yes I am revmoing them the way PowerBi says to. No it still is not working. Has not worked once. 

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        rbrownson,

        Would you mind sharing me the Excel file and PBIX file?


        Regards,