{"id":4653,"date":"2020-05-23T17:08:56","date_gmt":"2020-05-23T09:08:56","guid":{"rendered":"https:\/\/tommykwan.com\/blog\/?p=4653"},"modified":"2020-05-23T19:30:08","modified_gmt":"2020-05-23T11:30:08","slug":"importing-data-into-power-bi-desktop","status":"publish","type":"post","link":"https:\/\/tommykwan.com\/blog\/it\/power-bi\/importing-data-into-power-bi-desktop\/","title":{"rendered":"Importing Data into Power BI Desktop"},"content":{"rendered":"[Ref Beginning Microsoft Power BI ISBN 978-1-4842-5619-0]\n

The first step<\/strong> in creating the Power BI model is importing data<\/strong>. We can import data from a variety of data sources:<\/p>\n

    \n
  1. Relational Databases<\/li>\n
  2. Online sources\n
      \n
    1. Web services [online analytical processing (OLAP) database]<\/li>\n
    2. SQL Server Analysis Service (SSAS)<\/span><\/li>\n<\/ol>\n<\/li>\n
    3. Text Files<\/li>\n<\/ol>\n

      (Here are only few examples, there are far more sources in the software)<\/p>\n

       <\/p>\n

      The second step<\/strong> in creating the Power BI model is “data munging”<\/a><\/strong>. You create a connection, preview the data, and then import it into the model. Data from these sources often needs to be scrubbed and transformed (perform “data munging”<\/a>) before it can be useful and imported into a model. Power Query is<\/span> a powerful tool performing “data munging”<\/a> in Power BI.<\/p>\n

      The basic data munging skills include:<\/p>\n

        \n
      1. Cleanse data\n
          \n
        1. removing duplicates<\/li>\n
        2. replacing values<\/li>\n
        3. removing error values<\/li>\n
        4. changing data types<\/li>\n<\/ol>\n<\/li>\n
        5. filtering data (remove unnecessary columns and rows)<\/li>\n
        6. Merge (Columns)\n