Forum Discussion

Aruna_ln's avatar
Aruna_ln
Icon for Helper III rankHelper III
8 years ago
Solved

Directquery which one best sql statement or load into metadata

I have sql server database. i am connect DirectQuery without advance option my database metadata loaded 2.i am selwct advance option i am writing sql query. my question which one best. using sq...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Aruna_ln,

    If you know which columns or rows you will need to use in report, you can write SQL statement to import data to Power BI Desktop, this way, it will save you same time for handling data in Power BI Desktop and can reduce your data model, which will improve performance of your report in some extent.

    However, if you are not sure which columns or rows you need, you can directly load all the metadata into Power BI Desktop without writing SQL query.

    Regards,
    Lydia

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Aruna_ln,

If you know which columns or rows you will need to use in report, you can write SQL statement to import data to Power BI Desktop, this way, it will save you same time for handling data in Power BI Desktop and can reduce your data model, which will improve performance of your report in some extent.

However, if you are not sure which columns or rows you need, you can directly load all the metadata into Power BI Desktop without writing SQL query.

Regards,
Lydia