To get Google Sheets data into Power BI, you need only the sheet’s URL in Google Drive. To demonstrate, let’s use the Google Sheets file from the previous section as follows: 1.

In Power BI, hover over Get Data from the toolbar at the top of the screen to see the drop down menu. Select the Text/CSV option from the drop-down menu to import the CSV file ( Figure B ). Figure B ...