Forum Discussion
Refreshing data through Onedrive
Local Excel
Source = Excel.Workbook(File.Contents("C:\Users\xxxxxxxxxxxxxxxxxxxxxx\Device-Order-Data-CDN.xlsx"), null, true),
Onedrive
Source = Excel.Workbook(Web.Contents("https://xxxxxxxxxxxxxxxxxxxxxxxxxxxxx/Documents/Device-Order-Data-CDN.xlsx"), null, true),
Dear danielhunter i have been able to resolve this... for some wiered reason the problem was with the Link i was getting from the file... It was completely different than what you showed me.
Today again i gave it a try to change the source from excel file on my local machine to Excel on One Drive.
I uploaded the file on OneDrive opened them in Excel ( not excel Online) the difference i noticed this time before i could copy the link was that it gave a message that the file is opened in "Offiline Mode" .
Then copied the link from the file. In PBI went to "Data source settings" and changed the link (removed web=1) from the end saved and published on Service.
I also tested it...
Method was :Deleted the file from Onedrive.
I had the original file on my Laptop. ( Name of the file is same)
Deleted some rows from the file and saved it.
Uploaded this file on Ondrive.
Refreshed data manually after 5 mins.
Data and visuals are updated with change.
Root of the issue was link and i dont know why :D .
v-huizhn-msft i have already created the report on PBI desktop, cannot afford to recreate it... moreover i am getting totally different options ...
Now i am trying change the source of the file from my local machine to the OneDrive.
Below is what i did...
1. Uploaded the excel file i used in my report which is developed on my laptop.
2. Right Click on the file >Open in Excel>File>Info>Under Info is the name of my file >Click on Test>Click on Copy Link to Clipboard
Click on Test>Click on Copy Link to Clipboard
3. In PBI desktop Edit Queries>Data Source Settings>Data source in current File>Select the file to replace the source with>Change Source>Basic(the header of the dialouge box says "Excel" since the original file was an excel on local machine and under the File Path box change the "open file as" from "Excel" to "Html page"> Paste the link copied (remove"web=1" as suggested in this document [ https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-use-onedrive-business-links/ ] )> click "ok"> Select"Organisational account> Enter credential to sign in.
> Click ok > Click "Apply Changes" Then i get this error message
I hope i have explain it throughly :).
Local Excel
Source = Excel.Workbook(File.Contents("C:\Users\xxxxxxxxxxxxxxxxxxxxxx\Device-Order-Data-CDN.xlsx"), null, true),
Onedrive
Source = Excel.Workbook(Web.Contents("https://xxxxxxxxxxxxxxxxxxxxxxxxxxxxx/Documents/Device-Order-Data-CDN.xlsx"), null, true),
Dear danielhunter i have been able to resolve this... for some wiered reason the problem was with the Link i was getting from the file... It was completely different than what you showed me.
Today again i gave it a try to change the source from excel file on my local machine to Excel on One Drive.
I uploaded the file on OneDrive opened them in Excel ( not excel Online) the difference i noticed this time before i could copy the link was that it gave a message that the file is opened in "Offiline Mode" .
Then copied the link from the file. In PBI went to "Data source settings" and changed the link (removed web=1) from the end saved and published on Service.
I also tested it...
Method was :Deleted the file from Onedrive.
I had the original file on my Laptop. ( Name of the file is same)
Deleted some rows from the file and saved it.
Uploaded this file on Ondrive.
Refreshed data manually after 5 mins.
Data and visuals are updated with change.
Root of the issue was link and i dont know why :D .