This has been requested, but I felt it wasn't presented in the best (most forceful?) way. Azure Table Storage is for PETAbytes of structured data according to your own marketing material. If you do...
Indeed, PowerBI is unusable in (our) real world IoT scenarios for this very reason. We are storing IoT time series data and events in table storage. For thousands of devices with one minute intervals, this is millions of rows per day, and our customers would like to go still faster. A nightly refresh just crashes, even when retrieving one day of data. When it would work that would still mean you can only look at yesterday, not at today. And we would have to retrieve ridiculous amounts of data from table storage in every refresh, but almost none of that data is used (you only look at a dozens of devices per day). There are aggregation use cases which we could do in PowerBI by doing the aggregation outside of PowerBI ourselves, but that too ends with the user wanting to drill down / zoom in to the actual data. PowerBI, great tool, if only we could use it!
