Forum Discussion

ldacey's avatar
ldacey
Advocate I
9 years ago
Solved

Questions 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...
Need Help
  • v-sihou-msft's avatar
    v-sihou-msft
    9 years ago

    ldacey

     

    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's avatar
v-sihou-msft
Microsoft Employee
9 years ago

ldacey

 

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