Forum Discussion

SeattleCrime's avatar
SeattleCrime
Icon for Helper I rankHelper I
4 years ago
Solved

Power BI Service data refresh due to data type error + Power BI Desktop Error applying Power Query

Short story: this is a public report with an OData feed.   Longer story: About 6 weeks ago, the automated daily data refresh to a public Power BI report that's been live for a year stopped working....
Need Help
  • lbendlin's avatar
    lbendlin
    4 years ago

    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.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
4 years ago

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.

SeattleCrime's avatar
SeattleCrime
Icon for Helper I rankHelper I
4 years ago

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.