If you want to know how to connect google sheets to Power BI, importing from Google Sheets, read this post. In Power BI, there are several sources for obtaining data and one of the most popular is Google Sheets. In addition to it, text files, .txt or .csv, SQL, Azure, SAP and Sales Force databases are widely used.
Knowing how to import a Google Sheets into Power BI is critical for users. Because, it is the most popular information storage software in the world. Companies that work in various segments use Google Sheets to do their controls.
In this post, we will guide you through the necessary steps to learn how to import data from google sheets to Power BI. So, follow the steps below and let us know in the comments if you were able to connect Power BI with Google Sheets.
How to import data from Google Sheets into Power BI
To send data from Google Sheets to Power BI, follow the steps below:
- Open the spreadsheet in Google Sheets.
- Click on the File tab.
- Click Share.
- Click Change to anyone with the link.
5. Click Copy Link.
- Open Power BI.
- Click the Home tab.
- Click Get Data.
9. Select Web.
- Select URL.
- Paste the Google Sheets url.
- Find the last slash sign of the address and edit the path:
export?format=xlsx
- Click OK.
- Check the check box for the table.
- Click Load.
After following the steps above, the data from Google Sheets will be inside Power BI.
Summary
Learn how to import data from Google Sheets into Power BI.
So, follow the steps above and let us know in the comments if you were able to load data from the Google table in Power BI.