Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
abadill
Resolver I
Resolver I

Se encontró un error al intentar conectarse. Para completar esta acción, actualice a Power BI Pro

Estimados, Tengo problemas para conectar un archivo de excel a Power BI Desktop, el problema es con un archivo en particular de excel formato xlsx Me sale un mensaje que dice: Se encontró un error al intentar conectarse. Detalles: "Para completar esta acción, actualice a Power BI Pro."

 

 

Yo tengo actualizado el Power BI desktop en mi máquina y tambien tengo habilitada la licencia Power BI Pro. Este error solo me sale con un archivo de excel, cuando subo otros archivos no me da este problema. Quiero entender por qué sucede esto y que hacer para solucionarlo

 

Gracias

Andrea 

1 ACCEPTED SOLUTION
v-rzhou-msft
Community Support
Community Support

Hi @abadill ,

 

As far as I know, normally Power BI Desktop does not require a Power BI Pro license for us to importing or connecting to Excel files.

The Power BI Pro license is primarily needed for sharing content and collaboration within the Power BI Service, not for the functionalities within Power BI Desktop itself.

 

Here I have some suggestions:

If you want to get data from Power BI semantic models in Excel, you must have a Fabric license: Fabric (free), Pro or Premium Per User (PPU).

Fabric free license users can only work with datasets in My workspace or a Power BI Premium capacity or Fabric F64 or greater capacity. 

For reference:

Connect Excel to Power BI semantic models - Power BI | Microsoft Learn

 

Connect to Excel file in Power BI:

Quickstart: Connect to data in Power BI Desktop - Power BI | Microsoft Learn

 

If this reply still couldn't help you solve your issue, please make sure whether there are some specific funtions in your file and please make sure the position of your excel file as lbendlin mentioned. (Online or local?)

 

Best Regards,
Rico Zhou

 

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

View solution in original post

2 REPLIES 2
v-rzhou-msft
Community Support
Community Support

Hi @abadill ,

 

As far as I know, normally Power BI Desktop does not require a Power BI Pro license for us to importing or connecting to Excel files.

The Power BI Pro license is primarily needed for sharing content and collaboration within the Power BI Service, not for the functionalities within Power BI Desktop itself.

 

Here I have some suggestions:

If you want to get data from Power BI semantic models in Excel, you must have a Fabric license: Fabric (free), Pro or Premium Per User (PPU).

Fabric free license users can only work with datasets in My workspace or a Power BI Premium capacity or Fabric F64 or greater capacity. 

For reference:

Connect Excel to Power BI semantic models - Power BI | Microsoft Learn

 

Connect to Excel file in Power BI:

Quickstart: Connect to data in Power BI Desktop - Power BI | Microsoft Learn

 

If this reply still couldn't help you solve your issue, please make sure whether there are some specific funtions in your file and please make sure the position of your excel file as lbendlin mentioned. (Online or local?)

 

Best Regards,
Rico Zhou

 

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

lbendlin
Super User
Super User

Is this a .xls or .xlsb file? Where is it stored?

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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