Forum Discussion
Power BI.com manual refresh breaking visuals
Ok, so after more than 3 hours on the phone with a very helpful Microsoft support member yesterday we managed to narrow this down.
The issue was being caused by data coming from one (or multiple) columns being imported from our MySQL database. The columns in MySQL are stored as datetime and originally I imported them directly and then set the column type in BI to date/time. This was working for a number of months until it stopped working as described above.
The solution here was to, in the SQL query, use CONVERT([column_name], CHAR) to convert the datetime value into a text string, import into PowerBI and THEN convert to date/time in Power BI.
The technician couldn't explain why this fixed things as he should direct import from datetime columns should work fine. They are trying to get me more info and I will update if they do.
Just posting in case useful for other people.
THanks ankitpatira. The same visuals used to work previously with no changes having been made to the visuals, underlying measures or table data formats. I am currently doing as you suggested and stripping out everything in the model to narrow down things.
I'm currently down to 2 tables and we'll see how it goes.
We're currently testing On-premises gateway.
Ok, so after more than 3 hours on the phone with a very helpful Microsoft support member yesterday we managed to narrow this down.
The issue was being caused by data coming from one (or multiple) columns being imported from our MySQL database. The columns in MySQL are stored as datetime and originally I imported them directly and then set the column type in BI to date/time. This was working for a number of months until it stopped working as described above.
The solution here was to, in the SQL query, use CONVERT([column_name], CHAR) to convert the datetime value into a text string, import into PowerBI and THEN convert to date/time in Power BI.
The technician couldn't explain why this fixed things as he should direct import from datetime columns should work fine. They are trying to get me more info and I will update if they do.
Just posting in case useful for other people.