Conexión de Excel en OneDrive Personal a Power Bi

[Mikaseido1]

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.

[Mikaseido1 · Accepted solution]

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]

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.