• 23. 5. 2020
  • Ing. Jan Zedníček - Data Engineer & Controlling
  • 0

Did it ever happen to you that the Power BI update did not work? There might be several reasons for this problem and it is always user’s fault. We will model a few of these situations on a timesheet. Our goal is to find out why the report refresh does not perform without an error. Problems occur mostly when working with source file types as Excel. If you are connecting on data to SQL Server database, you will probably encounter these errors less often.

Source data moved or the file changed its name

It is quite common we put the report together in a hurry in power bi desktop app from Excel data for example. We then upload it to web and after a while move the source Excel somewhere else or rename it. Pbi file (power bi desktop file) obviously remembers directions to original location and will signal error during report attempt.

Original source file Projekty.xlsx will be renamed to Projekty_.xlsx

and an error during Refresh attempt is born: Datasource.Error: Could not find file …..

POwer BI report nefunguje

It is Important to Secure Source Data Quality

Another common reason can be a mistake in data quality in some field of data type. Data type change in 1 cell of source Excel can result in the whole report stopping to work.

I will change the date in D6 cell to nonsense value 32.10.2017 (date doesnt exists)

What will happen during the report refresh attempt? The result is error 1 of the loaded queries contained Errors and the power bi update again does not work correctly. The report will stay in its original state.

Aktualizace power bi reportu nefunguje

When we click on view errors, Power query warns us about problem with upload of 1 row (the one we changed).

Change of data source type will also cause Power bi refresh to not work properly

Another cause can be change of data type in source data, even an unwanted one. Again, small incautiousness with one cell is enough. I will change data type in cell G8 from original type number to text, as seen in the picture below.

Again, we have exactly same error



Rate this post

Ing. Jan Zedníček - Data Engineer & Controlling

My name is Jan Zedníček and I have been working as a freelancer for many companies for more than 10 years. I used to work as a financial controller, analyst and manager at many different companies in field of banking and manufacturing. When I am not at work, I like playing volleyball, chess, doing a workout in the gym.

🔥 If you found this article helpful, please share it or mention me on your website

Leave a Reply

Your email address will not be published. Required fields are marked *