Connecting Data from Power Pivot with Power BI Desktop App

Hi guys,

Is there a way to connect the data from Power Pivot to Power BI Desktop App?

When I try to connect to the Excel file I can only select tables and sheets. The data is too big for a simple Excel table (>1Mio rows)

Thank you

Edit: Ah ok you don't use "Get Data" but "Import Excel Workbook Contents"