Forum Discussion
Report Template data set for report creation
hi, Anonymous
For point 1 and 2:
When you use power bi desktop connect to Snowflake as the data source. You could choose use "Import" or "Directquery" for it.
For the advantages and disadvantages between "Import" and "Directquery", please refer to this document:
https://docs.microsoft.com/en-us/power-bi/desktop-directquery-about
Whichever way you choose, you could transform data and create the data model for it, include measures or column.
For "import", the dataset couldn't be larger than 1GB for Free and pro user.
For "Directquery", there some Limited data transformations and Modeling limitations. but for the dataset is not in the local, so there is no dataset size limitation but it limit of one million rows returned on any query.
For point 3:
For the different report has a different data structure, for example table name, column name, Measrue name, so there is no template driven report development.
Best Regards,
Lin
Thank You Lin. I would like to understand which is the better option for creating a number of reports (These reports are complex reports) :-
1. Directly connecting to the Snowflake Star Schema and creating the reports
2. Publishing a power bi data set with pre-created measures and creating all the reports using live connection to this data set.
Are there any limitations in each approach and which would be recommended way
hi, Anonymous
If the dataset is not very big(1gb or if you have premium capacities you could use the pbix file up to a maximum of 10 GB in size), I would suggest you use "Import" model,
and if Data is very large and changing frequently, and near ‘real-time’ reporting is needed I would suggest "DirectQuery".
Best Regards,
Lin