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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

Reply
AMIGUELANEZ
Regular Visitor

Wait while we establish a connection with -binaryParameter when importing an excel file from sharep

The connection of this message does not progress.
It is an import of an excel file located in Sharepoint.

AMIGUELANEZ_0-1719911543411.png

 

1 REPLY 1
Anonymous
Not applicable

Hi @AMIGUELANEZ 

 

How do you connect to this Excel file? Do you use the SharePoint Folder connector or use the Web connector by passing the File URL? 

If you only connect to a single Excel file, can you connect to it successfully without the -binaryParameter? In addition, what does the -binaryParameter mean?

 

Anyway if you want to connect to an Excel file located in SharePoint Online, you can either

1. try the SharePoint folder connector, once connecting to a SharePoint folder, filter by Path or Name column to find the specific file you want, then get data from its binary content. 

2. try the Web connector and use the method introduced in the documentation: Use OneDrive for work or school links in Power BI Desktop - Power BI | Microsoft Learn

 

Let me know if you still have questions. 

 

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors