{"id":5525,"date":"2017-01-11T22:27:02","date_gmt":"2017-01-11T22:27:02","guid":{"rendered":"https:\/\/blogs.msdn.microsoft.com\/premier_developer\/?p=5525"},"modified":"2019-02-14T20:27:44","modified_gmt":"2019-02-15T03:27:44","slug":"parsing-folders-in-power-bi-and-adding-the-folder-name-as-a-column-in-the-power-query","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/premier-developer\/parsing-folders-in-power-bi-and-adding-the-folder-name-as-a-column-in-the-power-query\/","title":{"rendered":"Parsing folders in Power BI and adding the folder name as a column in the Power Query"},"content":{"rendered":"<p>Senior Application Development Manager, <a href=\"https:\/\/www.linkedin.com\/in\/robmreilly\">Robert Reilly<\/a>, walks us through parsing multiple files contained in multiple folders from Power BI.<\/p>\n<hr \/>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/wp-content\/uploads\/sites\/31\/2019\/04\/powerbi.png\"><img decoding=\"async\" width=\"324\" height=\"188\" title=\"powerbi\" align=\"right\" style=\"float: right;padding-top: 0px;padding-left: 0px;margin: 0px 0px 0px 10px;padding-right: 0px;border: 0px\" alt=\"powerbi\" src=\"https:\/\/devblogs.microsoft.com\/wp-content\/uploads\/sites\/31\/2019\/04\/powerbi_thumb.png\" border=\"0\" \/><\/a>On occasion you may have a need to parse multiple files contained in multiple folders from Power BI.\u00a0 As an example I am working with a colleague to generate some Power BI reports from CSV data files he has created some custom code to create by pulling data from another system.\u00a0 The code he uses creates a new folder that&#8217;s name is a timestamp of the day the job was run.\u00a0 The same 5 report names exists in each timestamp folder.\u00a0 Since Power BI does not currently support creating partitions for the data that is read in we needed a way to be able to partition the data by the timestamp.<\/p>\n<p><a href=\"https:\/\/www.linkedin.com\/today\/post\/article\/parsing-folders-power-bi-adding-folder-name-column-query-rob-reilly?trk=prof-post\" title=\"https:\/\/www.linkedin.com\/today\/post\/article\/parsing-folders-power-bi-adding-folder-name-column-query-rob-reilly?trk=prof-post\">Read the full story here.<\/a><\/p>\n<hr \/>\n<p><a href=\"https:\/\/blogs.msdn.microsoft.com\/b\/premier_developer\/archive\/2014\/09\/15\/welcome.aspx\"><strong>Premier Support for Developers<\/strong><\/a> provides strategic technology guidance, critical support coverage, and a range of essential services to help teams optimize development lifecycles and improve software quality.\u00a0 Contact your Application Development Manager (ADM) or <a href=\"https:\/\/blogs.msdn.microsoft.com\/premier_developer\/contact-us\/\">email us<\/a> to learn more about what we can do for you.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Senior Application Development Manager, Robert Reilly, walks us through parsing multiple files contained in multiple folders from Power BI. On occasion you may have a need to parse multiple files contained in multiple folders from Power BI.\u00a0 As an example I am working with a colleague to generate some Power BI reports from CSV data [&hellip;]<\/p>\n","protected":false},"author":582,"featured_media":37840,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[307,3],"class_list":["post-5525","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-permierdev","tag-powerbi","tag-team"],"acf":[],"blog_post_summary":"<p>Senior Application Development Manager, Robert Reilly, walks us through parsing multiple files contained in multiple folders from Power BI. On occasion you may have a need to parse multiple files contained in multiple folders from Power BI.\u00a0 As an example I am working with a colleague to generate some Power BI reports from CSV data [&hellip;]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/premier-developer\/wp-json\/wp\/v2\/posts\/5525","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/premier-developer\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/premier-developer\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/premier-developer\/wp-json\/wp\/v2\/users\/582"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/premier-developer\/wp-json\/wp\/v2\/comments?post=5525"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/premier-developer\/wp-json\/wp\/v2\/posts\/5525\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/premier-developer\/wp-json\/wp\/v2\/media\/37840"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/premier-developer\/wp-json\/wp\/v2\/media?parent=5525"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/premier-developer\/wp-json\/wp\/v2\/categories?post=5525"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/premier-developer\/wp-json\/wp\/v2\/tags?post=5525"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}