Global Power BI User Group

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
Expand all | Collapse all

Power BI filter out the data of related table while importing

  • 1.  Power BI filter out the data of related table while importing

    Posted Apr 21, 2017 07:45 AM

    Can we filter out the data of related table (dimension tables) on the basis of one table (fact table) while converting from Direct Query mode to import?

    For example – My fact table contains billions of records including date column. I want to import only current year data and the related dimension table should automatically filtered out on the basis of fact table. Is it feasible to achieve in Power BI?



    ------------------------------
    Rahul Mittal
    ------------------------------


  • 2.  RE: Power BI filter out the data of related table while importing

    Silver Contributor
    Posted Apr 21, 2017 11:13 AM
    You can apply Where condition in your SQL Queries.

    ------------------------------
    Vishal Pawar
    ------------------------------



  • 3.  RE: Power BI filter out the data of related table while importing

    Bronze Contributor
    Posted Jul 21, 2017 04:08 PM
    you can make the filter in the data preview stage when you make the connection to your data source. , you can filter on the desired date, before you make the data upload to your BI model.

    ------------------------------
    Ahmad ElGhazouly
    Information Systems Manager
    ------------------------------