Drew on 25 Mar 2020 22:21:25
When you are working in the Power BI desktop, it is much more forgiving of leaving columns as type "any". However, I've had issues where I don't realize I have a column that is not typed, and when I publish to the service and try to refresh the dataset, it throws an error that doesn't really tell me what the issue was. It would be really helpful for Power BI to warn you that you have an untyped column that is going to be an issue OR at least provide a better error when the refresh fails in the Power BI service.