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.
elongo When is the last time you refreshed the dataset? Do you have any page level or report level filters that are constraining the data set, and as each day goes by you are just no longer seeing it in the report?
I would create another report off the dataset and see if the data is actually being removed, or if it is some report setting.
My suggestion would be to raise a new topic yourself (in the Desktop forum) and not directly raise an issue if you don't know what is going on.
Please provide more information, as the issue may just be your queries and/or report definitions as already suggested by Anonymous
And please mind your CAPS LOCK as people may be less willing to react.