Forum Discussion

fersale's avatar
fersale
Frequent Visitor
4 years ago

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...
Need Help
AilleryO's avatar
AilleryO
Memorable Member
4 years ago

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

 

  • fersale's avatar
    fersale
    Frequent Visitor
    4 years ago

    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

  • fersale's avatar
    fersale
    Frequent Visitor
    4 years ago

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