In this Power BI Tutorial, Patrick looks at how to load data from a flat file to the data model. This could be a text, csv or excel file with a lot of columns. Don’t just pull it into Power BI. Take time to structure your data in your data model. From flat file to data model is basic concept, but is worth the time to get it right!<\/p>\n
LET’S CONNECT!<\/p>\n
Guy in a Cube
\n— https:\/\/guyinacube.com
\n— http:\/\/twitter.com\/guyinacube
\n— http:\/\/www.facebook.com\/guyinacube
\n— Snapchat – guyinacube
\n— https:\/\/www.instagram.com\/guyinacube\/<\/p>\n
***Gear***
\nCheck out my Tools page – https:\/\/guyinacube.com\/tools\/ #powerbi #guyinacube<\/p>\n","protected":false},"excerpt":{"rendered":"
In this Power BI Tutorial, Patrick looks at how to load data from a flat file to the data model. This could be a text, csv or excel file with a lot of columns....<\/p>\n","protected":false},"author":1,"featured_media":3282,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"video","meta":[],"categories":[547,583],"tags":[600,601,602,603],"youtube_video":{"channel_id":"UCFp1vaKzpfvoGai0vE5VJ0w","channel_title":"Guy in a Cube","title":"Power BI Tutorial | From Flat File To Data Model","description":"In this Power BI Tutorial, Patrick looks at how to load data from a flat file to the data model. This could be a text, csv or excel file with a lot of columns. Don't just pull it into Power BI. Take time to structure your data in your data model. From flat file to data model is basic concept, but is worth the time to get it right!\r\n\r\nLET'S CONNECT!\r\n\r\nGuy in a Cube\r\n-- https:\/\/guyinacube.com\r\n-- http:\/\/twitter.com\/guyinacube\r\n-- http:\/\/www.facebook.com\/guyinacube\r\n-- Snapchat - guyinacube\r\n-- https:\/\/www.instagram.com\/guyinacube\/\r\n\r\n***Gear***\r\nCheck out my Tools page - https:\/\/guyinacube.com\/tools\/ #powerbi #guyinacube","category_id":"28","category":"Science & Technology","tags":["Power BI Tutorial from flat file to data model","Power BI Tutorial | From Flat File to Data Model+","from flat file to data model","power bi tutorial","power bi tutorial for beginners","flat file","power bi","power bi data model tutorial","power bi data modeling","power bi desktop","power bi desktop tutorial for beginners","power bi desktop tutorial video","power bi get data","data","tutorial","data modeling","data modeling concepts","data modeling tutorial","power pivot","get & transform"],"duration":627,"iso_duration":"PT10M27S","human_duration":"10:27","definition":"hd","thumbnails":{"default":{"url":"https:\/\/i.ytimg.com\/vi\/vjBprojOCzU\/default.jpg","width":120,"height":90},"medium":{"url":"https:\/\/i.ytimg.com\/vi\/vjBprojOCzU\/mqdefault.jpg","width":320,"height":180},"high":{"url":"https:\/\/i.ytimg.com\/vi\/vjBprojOCzU\/hqdefault.jpg","width":480,"height":360},"standard":{"url":"https:\/\/i.ytimg.com\/vi\/vjBprojOCzU\/sddefault.jpg","width":640,"height":480},"maxres":{"url":"https:\/\/i.ytimg.com\/vi\/vjBprojOCzU\/maxresdefault.jpg","width":1280,"height":720}},"video_id":"vjBprojOCzU","published":"2018-06-13T15:00:15Z","stats":{"comments":"106","views":"58122","likes":"1536","dislikes":"15","favourite":"0"},"privacy":{"status":"public","embeddable":true,"license":"youtube"}},"_links":{"self":[{"href":"https:\/\/www.extradrm.com\/index.php?rest_route=\/wp\/v2\/posts\/3281"}],"collection":[{"href":"https:\/\/www.extradrm.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.extradrm.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.extradrm.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.extradrm.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3281"}],"version-history":[{"count":0,"href":"https:\/\/www.extradrm.com\/index.php?rest_route=\/wp\/v2\/posts\/3281\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.extradrm.com\/index.php?rest_route=\/wp\/v2\/media\/3282"}],"wp:attachment":[{"href":"https:\/\/www.extradrm.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3281"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.extradrm.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3281"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.extradrm.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3281"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}