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 ,
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
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
