Need Help/Advise on connecting azure table storage

[Ramakrishna537]

Hi ,

we need to connet to Azure Table storage and read few tables of data in power Bi Desktop.

Tables are containing large amount of data (each table had >5GB data).

1. is it possible to load data into PBI desktop and do grouping and aggrigations on top of the data ?

2.Is there any better alternatives instead of directly hitting ATS ?

Thanks in Advance .

[v-shex-msft]

Hi @Ramakrishna537,

>>1. is it possible to load data into PBI desktop and do grouping and aggrigations on top of the data ?

Yee, you can load them to power bi desktop. (but it will cause some performance issue due to data amount)
For your scenario, I'd like to suggest you only use summary data to create visuals.

>>2.Is there any better alternatives instead of directly hitting ATS ?

You can also try to use odata connector, but I don't think change connectors will increase the performance.

Add oData Paging to Azure Table Storage

Regards,

XIaoxin Sheng

[Ramakrishna537]

Hi @v-shex-msft,

Thanks for info. 

Curently we are using Kusto as reporting database and power bi to create dashboards. 

we are looking alternatives for Kusto , currently looking at Azure documnet DB , Azure Table Storeage and Azure Datalake as possible options .

Can you please suggest us which one we can go for ...and pro and cons for each stoarge type ?

Thanks in Advanse.

M Ramakriahna Reddy.

[v-shex-msft]

Hi @Ramakrishna537,

To be honest, I also not familiar with these azure data sources.
If you want to know difference between these datasources, I'd like to suggest you post to azure forum for further support.

Regards.

Xiaoxin Sheng

[Ramakrishna537]

Hi @v-shex-msft,

Thanks for the quick reply . 

loading data into PBI Desktop from azure table storage is taking very long time (More then hours ).

1.instead of loading entire data into PBI Desktop , how to get only summerize data into PBI desktop ?

[v-shex-msft]

Hi @Ramakrishna537,

>>1.instead of loading entire data into PBI Desktop , how to get only summerize data into PBI desktop ?

You can take a look at below links which told how to summary and grouping data by power query:

Grouping or Summarizing Data to Create Compelling Reports

Group rows in a table (Power Query)

Regards,

Xiaoxin Sheng

[Ramakrishna537]

Hi ,

we need to connet to Azure Table storage and read few tables of data in power Bi Desktop.

Tables are containing large amount of data (each table had >5GB data).

1. is it possible to load data into PBI desktop and do grouping and aggrigations on top of the data ?

2.Is there any better alternatives instead of directly hitting ATS ?

Thanks in Advance .