Forum Discussion
rbrownson
9 years agoRegular Visitor
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...
Anonymous
9 years agoNot applicable
Is the data source an Excel file? I've noticed that blank rows at the end of the data file can creep in and cause this problem. Best solution is to open it up in Power BI Desktop, and get the Edit Queries section to remove the rows that causing the blanks.
rbrownson
9 years agoRegular Visitor
Yes one of the sources is in an Excel File. I refresh the data manually and delete all blank and duplicated rows. I save my Desktop report but it does not refresh the online report on powerbi nor the published report on the web. I keep getting the refresh error.