Getting viable data from an Excel workbook into Power BI for data visualization purposes takes some specific preparation. Here is what you need to do.

How to import Google Sheets file into Power BI The long way to get data in a Google Sheets file into Power BI is to save the file as an Excel file and then open that file in Power BI.