{"id":3202,"date":"2021-04-10T11:35:05","date_gmt":"2021-04-10T18:35:05","guid":{"rendered":"https:\/\/SUMMALAI.COM\/?p=3202"},"modified":"2021-04-25T22:35:17","modified_gmt":"2021-04-26T05:35:17","slug":"how-to-connect-google-drive-to-power-bi-detail-steps","status":"publish","type":"post","link":"https:\/\/SUMMALAI.COM\/?p=3202","title":{"rendered":"How to Connect Google Drive to Power BI (Detail Steps)"},"content":{"rendered":"\n<p>Solution 1: Change the google share link<\/p>\n\n\n\n<p>Google share must be allowed everyone. At the end of the link, change from <\/p>\n\n\n\n<p><strong><em>\/edit?usp=sharing<\/em><\/strong><\/p>\n\n\n\n<p>to <\/p>\n\n\n\n<p><strong><em>\/export?format=xlsx<\/em><\/strong><\/p>\n\n\n\n<p>or<\/p>\n\n\n\n<p><em><strong>\/export?format=csv<\/strong><\/em><\/p>\n\n\n\n<p>depends on the file extentions.<\/p>\n\n\n\n<p>Ruth from Curbal posted a youtube demo and an invoked function to make it even easier.<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-4-3 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe title=\"#D30 How to connect Google Sheet with Power BI\" width=\"640\" height=\"480\" src=\"https:\/\/www.youtube.com\/embed\/2hFCeduIP6k?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>Solution 2: <em>Use the CData ODBC Driver<\/em> (NOT a free tool)<\/p>\n\n\n\n<p>More detail can be found here: https:\/\/www.cdata.com\/kb\/tech\/googledrive-odbc-power-bi.rst<\/p>\n\n\n\n<p>The following steps can be followed to connect Google Drive to Power BI:\u00a0<\/p>\n\n\n\n<ol class=\"wp-block-list\"><li>Start by specifying your connection in an OCBC DSN. All Google APIs can be integrated on behalf of either an individual or an organization, as per your requirement.&nbsp;<\/li><li>Once the DSN has been created, you can proceed with connecting the Google Drive DSN from the Power BI system. You can download the Power BI Desktop from here by clicking on \u201cDownload\u201d and then \u201cPower BI Desktop\u201d.<\/li><li>You need to open Power BI Desktop and click on \u201cGet Data\u201d.<\/li><li>Select the ODBC option in the panel.<\/li><li>From the menu, select the concerned DSN. You can also expand the \u201cAdvanced Options\u201d and use SQL queries that you want to use to import data.<\/li><li>In the navigator dialog box, select \u201ctables\u201d.<\/li><li>You can edit the query of the imported table in the \u201cQuery Editor\u201d. Here, you can connect your Google Drive data with other data sources for collaborative manipulation.&nbsp;<\/li><li>Click on \u201cLoad\u201d to pull data into Power BI and carry out any data executions as required.<\/li><\/ol>\n\n\n\n<p>After connecting your Google Drive to Power BI, you can visualise it according to your need in Power BI.<\/p>\n\n\n\n<p>Also if possible then convert to CSV and try to connect because the size will reduce and then you can easily connect.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"a4\">Limitations<\/h2>\n\n\n\n<p>Even though a step-wise procedure can enable a manual connection of Google Drive to Power BI, there are significant challenges that can be encountered with future updates and alterations.<\/p>\n\n\n\n<p>You might need to set a refresh on schedule or even execute manual refreshes as per demand for data to be kept consistent with the source updates. It can be a cumbersome process for large organisations where thousands of updates are being made by the second, and a manual monitoring process seems to be unfavourable.&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Solution 1: Change the google share link Google share must be allowed everyone. At the end of the link, change from \/edit?usp=sharing to \/export?format=xlsx or \/export?format=csv depends on the file extentions. Ruth from Curbal posted a youtube demo and an invoked function to make it even easier. Solution 2: Use the CData ODBC Driver (NOT <a class=\"read-more\" href=\"https:\/\/SUMMALAI.COM\/?p=3202\">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":[238,585,10,621],"tags":[668],"class_list":["post-3202","post","type-post","status-publish","format-standard","hentry","category-cloud","category-google-cloud","category-microsoft","category-power-bi","tag-connect-google-drive-to-power-bi"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts\/3202","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=3202"}],"version-history":[{"count":2,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts\/3202\/revisions"}],"predecessor-version":[{"id":3279,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts\/3202\/revisions\/3279"}],"wp:attachment":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3202"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3202"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3202"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}