PowerBI Report for operational reporting

[Anonymous]

Hi,

Users wants to view pivot like view with link to documents 7 multiple visuals/tabs, can powerbi handle a view of 200,000 rows with links to documents with good perfromances and slicing?

Basically what is the limits

regards 

[v-luwang-msft · Accepted solution]

Hi @Anonymous ，

In Power BI Desktop, there is no data volume limitation for a load.

However, when you want to publish a .pbix file to Power BI Service, the dataset of a single .pbix file must be smaller than 1 GB. Power BI Premium supports uploads of Power BI Desktop (.pbix) files that are up to 10 GB in size. Once uploaded, a dataset can be refreshed to up to 12 GB in size. To use a large dataset, publish it to a workspace that is assigned to Premium capacity.

Other limitations:

• Distinct values in a column - When caching data in a Power BI dataset (sometimes called 'Import' mode), there is a 1,999,999,997 limit on the number of distinct values that can be stored in a column.

• Row limit - When using DirectQuery, Power BI imposes a limit on the query results that are sent to your underlying data source. If the query sent to the data source returns more than one million rows, you see an error and the query fails. Your underlying data can still contain more than one million rows. You're unlikely to run into this limit as most reports aggregate the data into smaller sets of results.

• Column limit - The maximum number of columns allowed in a dataset, across all tables in the dataset, is 16,000 columns. This limit applies to the Power BI service and to datasets used in Power BI Desktop. Power BI tracks the number of columns and tables in the dataset in this way, which means the maximum number of columns is 16,000 minus one for each table in the dataset.

Reference:

File size limit increase to 1 GB

Power BI Premium support for large datasets

Considerations and limitations

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien

[TomMartens]

Hey @Anonymous ,

as the information you provide is scarce and the question broad, I can just provide a simple answer: yes, but it depends!

To get a feel of what's possible (depending on the architecture): watch this video: Unlock petabyte-scale datasets in Azure with aggregations in Power BI | Azure Friday - YouTube

Regards,

Tom

[Anonymous]

Hi,

Thank You, i unfortunately cant use Azure but have an on=prem sql dw

i want to setup links to documents for operational use as we move away from tabular cubes

please would this work, field hyperlink to document with operational view of thousands of records

Any examples or posts i can follow

thank you