Forum Discussion
ldacey
Advocate I
Advocate IQuestions about utilizing Parameters
Is it better to create a view in the database and have Power BI connect to that view, or would it be more viable to create parameters to filter data/queries? Say I have a table which is fairly ma...
It's better to import views instead of tables into Power BI to avoid strong dependency between the physical data model and the report. Please see: Data Import Best Practices in Power BI.
And I don't suggest use Query Parameter since it can't be used on Power BI Service.
Regards,
Simon Hou
v-sihou-msft
Microsoft Employee
Microsoft Employee
It's better to import views instead of tables into Power BI to avoid strong dependency between the physical data model and the report. Please see: Data Import Best Practices in Power BI.
And I don't suggest use Query Parameter since it can't be used on Power BI Service.
Regards,
Simon Hou