Forum Discussion
Power BI Service data refresh due to data type error + Power BI Desktop Error applying Power Query
Maybe you can describe which reports you want to run off the data. A lot of your transforms do not serve a real purpose (sorting rows or rearranging columns for example). If you cut out all the unnecessary transforms you get the best performance.
Maybe you can describe which reports you want to run off the data. A lot of your transforms do not serve a real purpose (sorting rows or rearranging columns for example). If you cut out all the unnecessary transforms you get the best performance.
Thanks lbendlin , I didn't realize that the sort and column rearranging would bog down Power BI so much when applying changes. I avoided taking those actions and was able to add the column and apply changes without issue.
I'm still unclear why exactly the report refresh ran into the data type error (below), but I'm going to publish this version that's been fully updated with the lastest data and see if hte public report will accept an auto-refresh.
The data provider was unable to convert the value '<pii></pii>' from the source data type 'VT_BSTR' to the expected data type 'VT_DATE'.
Could also have been caused by malformed data. I noticed a couple of empty date times and 0,0 locations.
Since it is an ODATA source you can consider prefiltering if that is appropriate.
The data loaded fine in my tests.
lbendlinthanks again for your assistance. The report I re-published was successfully auto-refreshed this morning with the automated batch via Power BI Service through OData's feed.