Skip to main content
Microsoft Idea

Power BI

Completed

Azure Table Storage

Vote (122) Share
Shichao Hu's profile image

Shichao Hu on 21 Nov 2014 07:01:39

Please add Azure Table Storage support as a data source

Comments (7)
Shichao Hu's profile image Profile Picture

Power BI User on 05 Jul 2020 22:24:53

RE: Azure Table Storage

Please, add it to dashboards

Shichao Hu's profile image Profile Picture

Ahmed Eltawil on 05 Jul 2020 22:08:42

RE: Azure Table Storage

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

Shichao Hu's profile image Profile Picture

Michael Blanton on 05 Jul 2020 22:04:22

RE: Azure Table Storage

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

Shichao Hu's profile image Profile Picture

Luke Latham on 05 Jul 2020 22:03:08

RE: Azure Table Storage

... 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.

Shichao Hu's profile image Profile Picture

Mark Macumber on 05 Jul 2020 22:00:09

RE: Azure Table Storage

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

Shichao Hu's profile image Profile Picture

Mini Nair on 05 Jul 2020 21:59:43

RE: Azure Table Storage

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!

Shichao Hu's profile image Profile Picture

Joshua on 05 Jul 2020 21:59:43

RE: 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?