fadee2
Active Member
- Joined
- Nov 7, 2020
- Messages
- 405
- Office Version
- 365
- Platform
- Windows
Hi All,
I created a Data Model in excel from a workbook that is stored on onedrive personal. I used the embed code from onedrive with Excel's Get and Transform feature to create that Data Model, by replacing embed with download. The link was working fine uptil now. but today when I did refresh query excel returned an error,
" We could not refresh the connectioned 'Query'. Here's the error messege we've got:
[Datasource.error] The downloaded data is HTML, which isnt expected Type. The URL might be wrong or you might not have provided the right credentials to the server."
I then logged in to my onedrive and tried the embed feature once again, and found out the embed code structure has changed.
Previously the embed code structure was like
"https://onedrive.live.com/embed?resid=xxxxxx"
and now it is like this
"https://1drv.ms/x/c/xxxxxxxxxxxx"
Looking at the new link, I think I understand why the error said THE URL MIGHT BE WRONG.
Had this happened to any one? Is there any info on this?
Now, how can I import data from my onedrive workbook to my local workbook, so that when the onedrive workbook is updated the data model can get updated data with Refresh All Button from Queries and Connection Group, in Excel?
Any help is highly appreciated.
I created a Data Model in excel from a workbook that is stored on onedrive personal. I used the embed code from onedrive with Excel's Get and Transform feature to create that Data Model, by replacing embed with download. The link was working fine uptil now. but today when I did refresh query excel returned an error,
" We could not refresh the connectioned 'Query'. Here's the error messege we've got:
[Datasource.error] The downloaded data is HTML, which isnt expected Type. The URL might be wrong or you might not have provided the right credentials to the server."
I then logged in to my onedrive and tried the embed feature once again, and found out the embed code structure has changed.
Previously the embed code structure was like
"https://onedrive.live.com/embed?resid=xxxxxx"
and now it is like this
"https://1drv.ms/x/c/xxxxxxxxxxxx"
Looking at the new link, I think I understand why the error said THE URL MIGHT BE WRONG.
Had this happened to any one? Is there any info on this?
Now, how can I import data from my onedrive workbook to my local workbook, so that when the onedrive workbook is updated the data model can get updated data with Refresh All Button from Queries and Connection Group, in Excel?
Any help is highly appreciated.
