{"id":3280,"date":"2021-04-26T09:32:51","date_gmt":"2021-04-26T16:32:51","guid":{"rendered":"https:\/\/SUMMALAI.COM\/?p=3280"},"modified":"2021-05-01T10:19:52","modified_gmt":"2021-05-01T17:19:52","slug":"how-to-connect-power-bi-to-a-file-folder-in-onedrive","status":"publish","type":"post","link":"https:\/\/SUMMALAI.COM\/?p=3280","title":{"rendered":"How to Connect Power BI to a File\/Folder in OneDrive"},"content":{"rendered":"\n<p>Here is a recent video that shows how to get data from a OneDrive file using the SharePoint Folder connector.\u00a0 <\/p>\n\n\n\n<p>Just build the new query, and then copy the steps of the new query and replace the Source (and maybe a few more steps) of your existing query.\u00a0 You may have to update your step references so the each step references the table\/variable before it (e.g., #&#8221;Changed Type&#8221;).\u00a0 <\/p>\n\n\n\n<p>WIth this approach, your original table will stay in the model with all the relationships, measures, visuals, etc. still intact.<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe title=\"Easiest and fastest way to get ANY  data from OneDrive for Business into Power BI\" width=\"640\" height=\"360\" src=\"https:\/\/www.youtube.com\/embed\/cxRacjMb47I?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<p>Below, it is another great video to find the path for a individual file in OneDrive.<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe title=\"How to use Power Query to connect to a file on OneDrive or SharePoint (\u26a0\ufe0f see update in links below)\" width=\"640\" height=\"360\" src=\"https:\/\/www.youtube.com\/embed\/igcCbKqtwrk?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Here is a recent video that shows how to get data from a OneDrive file using the SharePoint Folder connector.\u00a0 Just build the new query, and then copy the steps of the new query and replace the Source (and maybe a few more steps) of your existing query.\u00a0 You may have to update your step <a class=\"read-more\" href=\"https:\/\/SUMMALAI.COM\/?p=3280\">Read More<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[10,621],"tags":[],"class_list":["post-3280","post","type-post","status-publish","format-standard","hentry","category-microsoft","category-power-bi"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts\/3280","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3280"}],"version-history":[{"count":2,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts\/3280\/revisions"}],"predecessor-version":[{"id":3303,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts\/3280\/revisions\/3303"}],"wp:attachment":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3280"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3280"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3280"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}