Forum Discussion
Data capacity
1. Say that an organization has 1 TB of sales data, how does Power BI deals with such cases where data is much larger 10 GB limit?
The current path would be to have that data in a cube/model, Power BI can connect directly to that cube/model and not import the data.
2. If it can handle data chunks that are larger than 10 GB, does it use Azure? Each workspace/group is limited to 10GB of which all the info already sits in Azure.
3. If it can handle data chunks that are larger than 10 GB, how does it connects to local data sources such as an SQL database with data of 500 GBs? Direct Query to databases/cubes/models only queries the information, it doesn't import it.
Direct Query methods send queries to your data source (Database, cube/model) - the size of those datasources is not a factor because you are not importing the data into Power BI.
ozancavus The answer to all the queries is using Direct Query for supported data sources wherein data is not loaded into your Power BI Desktop model. It would be even great if you try importing data in SSAS model (tabular/multidimensional) and then create reports out of it ! But remember that direct query requires data sources connection to be always ON.
If SQL Server in Azure then the Azure VM / Azure Datawarehouse should not be paused / stopped.
1. Say that an organization has 1 TB of sales data, how does Power BI deals with such cases where data is much larger 10 GB limit?
The current path would be to have that data in a cube/model, Power BI can connect directly to that cube/model and not import the data.
2. If it can handle data chunks that are larger than 10 GB, does it use Azure? Each workspace/group is limited to 10GB of which all the info already sits in Azure.
3. If it can handle data chunks that are larger than 10 GB, how does it connects to local data sources such as an SQL database with data of 500 GBs? Direct Query to databases/cubes/models only queries the information, it doesn't import it.
Direct Query methods send queries to your data source (Database, cube/model) - the size of those datasources is not a factor because you are not importing the data into Power BI.
how much it's cost to have this kind of capacity?
aesculapius Somethin I realize hasn't been asked. Where are you pulling your data from, and how? The behaviour you describe will occur when you are streaming data into the Power BI Service and enabling the "historic data analysis". This method allows you to build reports, but there is a threshold for the amount of data it retains.
This thread contains the specific thresholds.
thanks for the information. btw how much would it cost for using that service preciesely. cause i calculated this would cost more than thousand dollar per month. thanks