Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
 View Only
  • 1.  Creation of SQL Tables for Power BI Dashboard

    Posted Jul 28, 2022 03:04 AM
    Is it good to create all necessary tables with calculated values on SQL database instead of calculating in Power Bi Dashboard

    Please advice

    ------------------------------
    Mukesh Khandelwal
    ------------------------------


  • 2.  RE: Creation of SQL Tables for Power BI Dashboard

    Silver Contributor
    Posted Aug 02, 2022 10:10 AM
    More information on your scenario would help understand context, but best practice is to push as much as you can upstream. This helps with both reusability and performance.

    Depending on your model size, using DAX to summarize data into a table can kill performance. Using M in Power Query to create a table is better, but the best option would be to transform the data in the SQL database through a view or query and bring that result into the report.

    ------------------------------
    Mike Kromminga
    Data Architect
    ------------------------------



  • 3.  RE: Creation of SQL Tables for Power BI Dashboard

    Posted Aug 08, 2022 04:46 AM
    Thanks Mike for the suggestions

    ------------------------------
    Mukesh Khandelwal
    ------------------------------



  • 4.  RE: Creation of SQL Tables for Power BI Dashboard

    Top Contributor
    Posted Aug 03, 2022 04:13 AM
    Hi,

    That is not a good practice to have kpis based on calculated columns built in Power Query or even coming from SQL Database.

    Having pre computed columns means that you store them in the data model even if you don't use them in the report.... When handling huge amount of datas, that is NEVER the good option, otherwise you will face performances issues.

    THe procees is the following
    SQL Database is made only to store datas and make queries in order to built the data model at the end. If you dont master SQL Language, you can perform tansformations in Power Query.

    Then when tables are ok, you can built your data model (star schema !!)

    When you have the proper data model then you can compute kpis in DAX using measures.

    Remember SQL databases are transactional tools while Power BI is an analytical tool

    Transactional ==> stores datas
    Analytical ==> analyses datas

    ------------------------------
    Nicolas MENDEZ
    Data & BI consultant
    Becom Consulting
    ------------------------------



  • 5.  RE: Creation of SQL Tables for Power BI Dashboard

    Posted Aug 08, 2022 04:45 AM
    Thanks Nicolas  for the suggestions

    ------------------------------
    Mukesh Khandelwal
    ------------------------------