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.

4. Sign into your Microsoft account and open Power BI as you normally do. When applying this to your own work, open the .pbix file to which you want to add the Google Sheets data.

Open Power BI Desktop. (A free version of Power BI Desktop is available, if necessary.) Open the sample data file. Click the ”Open” icon (shown in the red circle in the screenshot ”Opening the Sample ...