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 ...

There is no COUNTIF function in Microsoft Power BI. If you need to apply that logic, you’ll have to turn to other measures.