Forum Discussion
Scheduled Refresh and Refresh Now giving Error
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.
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.
rbrownson,
Would you mind sharing me the Excel file and PBIX file?
Regards,