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

[AMIGUELANEZ]

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

[Anonymous]

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!