Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Report Template data set for report creation

Hi Team, We are developing a number of Power BI reports using Snowflake as the data source. This is a migration project and we are migrating from OLAP cubes with excel reporting to Snowflake with Po...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

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

v-lili6-msft's avatar
v-lili6-msft
Icon for Community Support rankCommunity Support
6 years ago

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