cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Dandelion0124 Frequent Visitor
Frequent Visitor

azure table storage Data size limit

Hi all,

 

We want to use Power BI dashboard to show the data from data source Azure Table Storage. And we have met the problem that by using the import way, the Power BI dataset will have the limit of 1G for each dataset. Our data size will be large. The Direct Query way has no size limit but will not support Table storage as the data resource. We want to know how to avoid this limitation?

 

Great thanks,

Wenjing Zhao

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: azure table storage Data size limit

HI @Dandelion0124,

 

#1. You can take a look at below blog:
Warning! Misleading Power Query Filtering

 

#2. You can achieve it by filter on query editor or setting filter query at advanced option. (the filters on data view not really reduce data amount, it will hide records on visuals)

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, please consider Accept it as the solution to help the other members find it more quickly
Learning resources: Power BI

View solution in original post

4 REPLIES 4
Community Support Team
Community Support Team

Re: azure table storage Data size limit

HI @Dandelion0124,

 

In fact, do some summary on records or adding some filters will reduce data amount.


In addition, if you cannot use the above operations to reduce the data amount and report size, you can consider to use power bi premium license, which allows you to use a larger data set.

Power BI Premium support for large datasets

 

Regards,
Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, please consider Accept it as the solution to help the other members find it more quickly
Learning resources: Power BI
Dandelion0124 Frequent Visitor
Frequent Visitor

Re: azure table storage Data size limit

Hi Xiaoxin,

 

Thanks for your reply.

I know Power Bi will do some compression for the data import but I don't know exactly.

So I have other two questions as following:

1. Where can I find the best practices for the data filtering in power BI? (such as "convert string to int")

2. For the data filtering, I have found the "advanced editor" to do the data filter, is it the only way to do the filtering?

 

Many thanks.

Wenjing Zhao

Community Support Team
Community Support Team

Re: azure table storage Data size limit

HI @Dandelion0124,

 

#1. You can take a look at below blog:
Warning! Misleading Power Query Filtering

 

#2. You can achieve it by filter on query editor or setting filter query at advanced option. (the filters on data view not really reduce data amount, it will hide records on visuals)

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, please consider Accept it as the solution to help the other members find it more quickly
Learning resources: Power BI

View solution in original post

Dandelion0124 Frequent Visitor
Frequent Visitor

Re: azure table storage Data size limit

Great thanks.

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors