The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi,
We are using Impala for data source and working on import mode.
I would like to know the behavior of gateway when dataset has more than 10 million rows that needs to be imported.
1. Will it import only first 10 million rows?
2. If the data set has 12 million rows.... Will it import remaining 2 million rows in the next hr ?
3. Will the refresh fail altogether (no rows will be updated)?
Thanks,
Mannu
Solved! Go to Solution.
Hi @Anonymous,
1. Yes, it will take two hours if there is no error shown.
2. Your understanding is right.
Best Regards,
Angelia
Is there a stated limitation for that connector? I didn't see one when research real quick.
Hi @Anonymous,
If you've got Pro account it takes an hour to load 1M rows in power bi service. For free account total size of all datasets can be maximum 1GB. For Pro it is 10GB. Each dataset cannot be more than 1GB for both free and Pro account.
Best Regards,
Angelia
Thank you Angelia for the response.
I have a Pro License.
Let me re-phrase my question.
1. If I configure a daily refresh and have 2 million rows of data, will it continue beyond an hour and take take 2 hrs to complete the refresh or will it simply fail? We can assume that size of data set < 1 GB and total number of columns is also well within the max-limit.
2. When the limit per dataset is specified as 1 GB, we are referring to the size after compression (the size of data as we see on the portal). Is my understanding correct?
Thanks,
Mannu
Hi @Anonymous,
1. Yes, it will take two hours if there is no error shown.
2. Your understanding is right.
Best Regards,
Angelia
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
55 | |
42 | |
23 | |
23 | |
16 |