Azure Table Storage

I can see that Power BI Designer supports Azure table storage. Please add this to the data sources for the dashboard. Right now we have to upload our pbix file everyday. Could we use the API for this perhaps?

Hey Joshua, We are working on supporting refresh of pbix files from within the Power BI service. As soon as it is supported, you'll be able to schedule refresh on your pbix file & no longer worry about uploading a new file everyday. This feature is coming soon!

I would love this too, but its critical that you allow for filtering of data during the import, especially from a partition and row key perspective, the Windows Azure diagnostics (WAD) data that we log is massive and needs to be filterable without full table scans

... and picking up on what Mark said: Keep in mind that with ATS that many tables will be reverse sorted by having Date.MaxValue - Date.UtcNow in one of the keys (i.e., TimeSpan values stored for the sort). We need Date.MaxValue, which is 12/31/9999 23:59:59.9999999, and we need to be able to add and subtract date values, in addition to the normal .AddDays, .AddHours, .AddMinutes, etc. functions that you normally provide. This is also a problem with ADF, and I hope that team add these important functions to ATS querying in their system, too.

Given that Azure Diagnostics writes to table storage, it would make it very easy to produce PowerBI reports around system utilization and other metrics.

This would be a huge win if we had Table Storage as a connection.

Please, add it to dashboards