Connecting to Azure Data Lake

[Anonymous]

Hi, I am very new to Microsoft Azure.
I have a customer who uses Azure Data lake as a data source and has more than millions of rows in the data source.
And I must tell them what kind of license they need to handle this kind of big data.

When connecting to Azure Data lake, do I first connect from the Power BI desktop, create the report, and publish it to the service?
Can I publish this amount of data to the Power BI service with a pro license, or what kind of license do I need?

Can Power BI desktop handle this amount of data?

What is the maximum data size limit that I can publish from the Power BI desktop to the service if I have a Premium per-user license?

Regards,

[v-yalanwu-msft]

Hi, @Anonymous ;

Is the above answer helpful to you? If so, Would you mind accept the helpful replies as solutions? Then we are able to close the thread. More people who have the same requirement will find the solution quickly and benefit here. Thank you.

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-yalanwu-msft]

Hi， @Anonymous ；

According to the offical document, 

• There's a one-million-row limit for cloud sources, Certain limits may be raised when using Premium capacity. The limit doesn't affect aggregations or calculations used to create the dataset returned using DirectQuery. It only affects the rows returned. Premium capacities can set maximum row limits, as described in this post.

  For example, you can aggregate 10 million rows with your query that runs on the data source. The query accurately returns the results of that aggregation to Power BI using DirectQuery if the returned Power BI data is less than 1 million rows. If over 1 million rows are returned from DirectQuery, Power BI returns an error (unless in Premium capacity, and the row count is under the admin-set limit).

So, you could set the admin limit.

https://community.powerbi.com/t5/Service/Direct-Query-1-million-row-limitation-in-Power-BI-Premium/m-p/847202

https://powerbi.microsoft.com/en-us/blog/five-new-power-bi-premium-capacity-settings-is-available-on-the-portal-preloaded-with-default-values-admin-can-review-and-override-the-defaults-with-their-preference-to-better-fence-their-capacity/

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , what is the total data volume. It depends on that?

[Anonymous]

@amitchandak  Thank you for your reply. They don't know at the moment. Can you give me general information?

What is the maximum data size limit that I can publish from the Power BI desktop to the service if I have a Premium per-user license?
Thanks