How to use Google Sheets data in Microsoft Power BI
Lots of users are turning to Google Sheets because it’s free and easy to use. Microsoft is probably feeling Google’s influence because the latest version of Microsoft Edge interfaces with Microsoft 365, and the dashboard looks a bit like Google Drive.
With many users and even organizations turning to Google Sheets, you might find yourself needing to import data from Google Sheets into Microsoft Power BI. The capability to do so has been around for almost a year so it might be beneficial to learn how. Fortunately, it’s easy.
In this tutorial, I’ll show you how to import data from Google Sheets into Microsoft Power BI. We’ll also review how to import Microsoft Excel data into Google Sheets and vice versa. I’m using Google Sheets in Microsoft Edge and Microsoft Power BI on a Windows 10 64-bit system. You can download the demo file for this tutorial.
How to upload and save an Excel file as a Google Sheets file
Google Drive lets you upload and store an Excel file without forcing you to convert the .xlsx file to a Google Sheets file. After all, Google Drive is about storage, not format. Later, if you decide to save the .xlsx file as a .gsheet file, Google Sheets won’t replace the Excel file. Rather, it creates a new Google Sheets file — you end up with an .xlsx and .gsheet file in Google Drive. Read More...
