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 13 days ago
    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 8 days ago
    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 2 days ago
    Thanks Mike for the suggestions

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



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

    Top Contributor
    Posted 7 days ago
    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 2 days ago
    Thanks Nicolas  for the suggestions

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