{"id":658,"date":"2023-10-22T10:13:15","date_gmt":"2023-10-22T09:13:15","guid":{"rendered":"https:\/\/nikasoftware.com\/?p=658"},"modified":"2023-10-22T10:18:30","modified_gmt":"2023-10-22T09:18:30","slug":"connect-onedrive-to-ms-excel-power-bi","status":"publish","type":"post","link":"https:\/\/nikasoftware.com\/index.php\/2023\/10\/22\/connect-onedrive-to-ms-excel-power-bi\/","title":{"rendered":"Connect OneDrive to MS-Excel \/ Power BI"},"content":{"rendered":"\n

Are you want Connect online OneDrive to MS-Excel \/ Power Bi<\/strong> for your data as you have not enough time to open OneDrive continuously? it is automatically updating process, just one time setup.<\/p>\n\n\n\n

Then you will be the right place, here we will learn how to connect OneDrive to excel<\/strong>? for this you have latest version to be available of MS-Excel. Let’s learn.<\/p>\n\n\n\n

Step:- 01<\/h2>\n\n\n\n

First of all, open your OneDrive and select your excel file that is connect to MS-Excel then right click on file then click on Embed <\/strong>button.<\/p>\n\n\n\n

\"Connect<\/figure>\n\n\n\n

Step:- 02<\/h2>\n\n\n\n

Now you will see a window on right side like below.<\/p>\n\n\n\n

\"connect<\/figure>\n\n\n\n

Step:- 03<\/h2>\n\n\n\n

Here Click on generate button for generating embed code.<\/p>\n\n\n\n

\"connect<\/figure>\n\n\n\n

here we will get the embed code<\/strong>, that we used for getting the address of File.<\/p>\n\n\n\n

Step:- 04<\/h2>\n\n\n\n

Then Copy the embed code<\/strong> and paste in any notepad file, then edit it. here we select only URL from ” http:\/\/……….2″ and delete rest code. <\/p>\n\n\n\n

Here in URL, we replaced embed<\/strong> with download<\/strong> and add &app-Excel after <\/strong>2 like in below figure.<\/p>\n\n\n\n

\"coneect<\/figure>\n\n\n\n
\"coneect<\/figure>\n\n\n\n
\"coneect<\/figure>\n\n\n\n

Step:- 05<\/h2>\n\n\n\n

After correction of URL copy it and paste it in excel>Data tab>from web<\/p>\n\n\n\n

\"coneect<\/figure>\n\n\n\n
\"coneect<\/figure>\n\n\n\n

Step:- 06<\/h2>\n\n\n\n

Then Click on ok<\/p>\n\n\n\n

\"coneect<\/figure>\n\n\n\n

Step:- 07<\/h2>\n\n\n\n

Here we will find new dialog box, after some time processing. then select sheet that you want to extract to excel and press Load To<\/strong> button that is given in bottom of dialog box.<\/p>\n\n\n\n

\"coneect<\/figure>\n\n\n\n
\"coneect<\/figure>\n\n\n\n

Step:- 08<\/h2>\n\n\n\n

we want to export data from OneDrive to MS-excel so we use Load To<\/strong> after that click on ok and in few seconds your data will be available here.<\/p>\n\n\n\n

\"coneect<\/figure>\n\n\n\n
\"coneect<\/figure>\n\n\n\n

It is online data if any changes in OneDrive file, then it will be also reflected here. and it is automatically update by simple Right click <\/strong>on table and click on Refresh<\/b>. <\/strong>Enjoy Thank you<\/p>\n\n\n\n

\n\n\n\n

<\/p>\n\n\n\n

<\/p>\n\n\n\n

<\/p>\n","protected":false},"excerpt":{"rendered":"

Are you want Connect online OneDrive to MS-Excel \/ Power Bi for your data as you have not enough time to open OneDrive continuously?<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[24],"tags":[36,37,38],"class_list":["post-658","post","type-post","status-publish","format-standard","hentry","category-ms-excel-tips-and-tricks","tag-connect-onedrive","tag-onedrive-to-excel","tag-onedrive-to-powerbi"],"_links":{"self":[{"href":"https:\/\/nikasoftware.com\/index.php\/wp-json\/wp\/v2\/posts\/658","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nikasoftware.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/nikasoftware.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/nikasoftware.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/nikasoftware.com\/index.php\/wp-json\/wp\/v2\/comments?post=658"}],"version-history":[{"count":6,"href":"https:\/\/nikasoftware.com\/index.php\/wp-json\/wp\/v2\/posts\/658\/revisions"}],"predecessor-version":[{"id":679,"href":"https:\/\/nikasoftware.com\/index.php\/wp-json\/wp\/v2\/posts\/658\/revisions\/679"}],"wp:attachment":[{"href":"https:\/\/nikasoftware.com\/index.php\/wp-json\/wp\/v2\/media?parent=658"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nikasoftware.com\/index.php\/wp-json\/wp\/v2\/categories?post=658"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nikasoftware.com\/index.php\/wp-json\/wp\/v2\/tags?post=658"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}