Reply
Mikaseido1
Frequent Visitor

Conexión de Excel en OneDrive Personal a Power Bi

Buenas tardes

 

Estoy tratando de conectar un archivo de Excel en OneDrive Personal a Power Bi, pero me esta generando error:

 

Anteriormente los link para vincular en Power Bi salian de la siguiente manera:

 

<iframe src="https://onedrive.live.com/embed?resid=123A549853801D71%21567&authkey=!ABAPXsGfNEm3tnU&em=2" width="402" height="346" frameborder="0" scrolling="no"></iframe>

 

Con los arreglos, quedaba de la siguiente manera:

https://onedrive.live.com/download?resid=123A549853801D71%21656&authkey=!ACdQwfQMHRvwCw0&em=Excel

 

Ahora el link se genera de la siguiente manera:

 

<iframe src="https://1drv.ms/x/s!AnEdgFOYVDoShjaH3V8YG-QWQe3k?embed=1&em=2" width="402" height="346" frameborder="0" scrolling="no"></iframe>

 

Como puedo ver, cambio en la totalidad el formato de la URL pero ahora no funciona a cargarlo en Power Bi.

 

Agradezco de la ayuda.

1 ACCEPTED SOLUTION
Mikaseido1
Frequent Visitor

Buenas noches

 

De acuerdo a la información enviada, me permito compartir la solución:

 

Copie el link de origen:

 

https://onedrive.live.com/embed?resid=123A549853801D71%21822&authkey=%21AIfdXxgb5BZB7eQ&e

 

Con los ajustes quedo de la siguiente manera:

 

https://onedrive.live.com/download?resid=123A549853801D71%21822&authkey=%21AIfdXxgb5BZB7eQ&e

 

Funciono correctamente, agradezco la ayuda.

View solution in original post

2 REPLIES 2
Mikaseido1
Frequent Visitor

Buenas noches

 

De acuerdo a la información enviada, me permito compartir la solución:

 

Copie el link de origen:

 

https://onedrive.live.com/embed?resid=123A549853801D71%21822&authkey=%21AIfdXxgb5BZB7eQ&e

 

Con los ajustes quedo de la siguiente manera:

 

https://onedrive.live.com/download?resid=123A549853801D71%21822&authkey=%21AIfdXxgb5BZB7eQ&e

 

Funciono correctamente, agradezco la ayuda.

v-jialongy-msft
Community Support
Community Support

Hi @Mikaseido1 

To fix this issue, you can try the following steps:

Get the correct OneDrive link:

Open your Excel file in OneDrive.
Click "Share" and select "Copy Link."
Make sure the link has "Anyone with the link can see" permissions.

Modify the binding for Power BI:

The link you get may have a different format. You need to modify it to make it compatible with Power BI.
Change the part of the link that says ?id= to download?resid= and remove any other parts that aren't needed.
For example, if your original link is:

https://onedrive.live.com/?id=123A549853801D71%21656&authkey=!ACdQwfQMHRvwCw0
It should look like this:

https://onedrive.live.com/download?resid=123A549853801D71%21656&authkey=!ACdQwfQMHRvwCw0 

Try in Power BI:
Open Power BI and select "Get data."
Choose "Web" and paste the modified link.

If you're still having trouble, make sure that the Excel file is properly shared and that the permissions are appropriate. You can also try updating Power BI to the latest version, as sometimes updates fix compatibility issues.

 

 

 

 

 

 

Best Regards,

Jayleny

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)