Power Bi connection with ODB (Excel File)

[Syndicate_Admin]

Hi
I'm relatively new to Power BI, I have an exel spreadsheet with 80,000 rows and I would like to import it into power BI using an ODBC connection, so that before importing I can make a query bringing only what I need.
however, I can't make the connection string with the Excel table.
The Excel file is saved locally, I've tried everything, I would really appreciate the help of this community to make this connection.

Yours sincerely

[Syndicate_Admin]

Hi,

Why not using the regular Excel file connection ?

And then use Power Query to filter the data you need ?

Power Query will analyse the 1000 first rows of your source, and offers you the possibility to filter, transform, agregate the data you need.

Then you'll work on your visual and calculation in DAX with Power BI Desktop and it should be fine.

I've been working with Excel files even longer than 100 000 rows without any problems.

Hope it helps

[Syndicate_Admin]

Thank you for your answer, however I hope to have a performance gain, in this way I hope to eliminate many unnecessary steps

Yours sincerely

[Syndicate_Admin]

so, you wouldn't have any example for me to use?

[Syndicate_Admin]

Hi @fersale ,

If you want to filter before importing, you can import the excel data to SQL Server database first. When you connect SQL Server to Power BI Desktop, specify a SQL statement to filter.

Reference: Tutorial: Connect to on-premises data in SQL Server - Power BI | Microsoft Docs.

Best Regards,

Stephen Tao

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

[Syndicate_Admin]

Hi @fersale ,

Could you tell me if your problem has been solved?
If it is, kindly Accept it as the solution. More people will benefit from it.
Or you are still confused about it, please provide me with more details about your problem.

Best Regards,
Stephen Tao

[Syndicate_Admin]

Hi

It's not a problem per se, I appreciate the answers given earlier, but it's not what I want to do.

I would like to know if it is possible to connect to an excel table via ODBC. I want this because it would allow me to process the data through an SQL query, thus eliminating some ETL steps, which in my opinion slow the query down.

thank you for your attention