For Database (Data Warehouse)

Hi kamrankhan ,

If the data is relatively small and needs to be updated in real time, using Google Sheets directly in Power BI may be the best option. However, if you are working with large datasets or need advanced data management and analytics capabilities, it may be more beneficial to connect Google Sheets to the warehouse first.

Here are two ways to connect to Google Sheets.

1. Power BI Desktop connects directly to Google Sheets.

For the first way, it is convenient and quick to realize the direct connectivity effect, as well as reflecting the data on Power BI Desktop in real time and quickly. At the same time it avoids the extra costs associated with warehouse.

However, it has its drawbacks as well, it cannot handle large data sets and once it encounters a large data set it will degrade the performance of Power BI. It also reduces the quality of protected data when not using a warehouse.

2. Connect to Google Sheets through the warehouse, and then use Power BI Desktop to connect to the warehouse.

For the second approach, warehouse is designed to handle large amounts of data, making it suitable for growing data sets. It can also perform complex queries and analysis on data before it reaches Power BI.
However, setting up and maintaining a warehouse is more complex and requires some specialized knowledge, and the cost of a warehouse is higher, especially if you need high performance and storage capabilities.

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.