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,
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
so, you wouldn't have any example for me to use?