Forum Discussion
Power Bi connection with ODB (Excel File)
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 bring...
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.