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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

AugPowerBI_Carousel

Power BI Monthly Update - August 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

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