Hi @meghanamane ,
To apply parameters for GA4 date in Power BI, you can follow these steps:
1. Open Power BI and click on "Edit Queries" in the Home tab.
2. In the Queries pane, select the query you want to apply the parameter to.
3. Click on "Manage Parameters" in the Home tab.
4. In the Manage Parameters dialog box, click on "New Parameter" to create a new parameter.
5. Give the parameter a name and select "Date/Time" as the data type.
6. Set the minimum and maximum values for the parameter. These values should correspond to the date range you want to analyze in GA4.
7. Click on "OK" to save the parameter.
8. In the Queries pane, select the query you want to apply the parameter to.
9. Click on "Add Column" in the Home tab and select "Custom Column".
10. In the Custom Column dialog box, enter the following formula: = GoogleAnalytics.Account("Your Account ID", "Your Property ID", [Start Date Parameter], [End Date Parameter])
11. Replace "Your Account ID" and "Your Property ID" with your own GA4 account and property IDs.
12. Replace [Start Date Parameter] and [End Date Parameter] with the names of the parameters you created in step 5.
13. Click on "OK" to create the custom column.
14. Click on "Close & Apply" in the Home tab to apply the changes to your query.
Best regards.
Community Support Team_Caitlyn
v-xiaoyan-msft
on:
Error (Exception from HRESULT: 0x80070002)
Hi @meghanamane ,
To apply parameters for GA4 date in Power BI, you can follow these steps:
1. Open Power BI and click on "Edit Queries" in the Home tab.
2. In the Queries pane, select the query you want to apply the parameter to.
3. Click on "Manage Parameters" in the Home tab.
4. In the Manage Parameters dialog box, click on "New Parameter" to create a new parameter.
5. Give the parameter a name and select "Date/Time" as the data type.
6. Set the minimum and maximum values for the parameter. These values should correspond to the date range you want to analyze in GA4.
7. Click on "OK" to save the parameter.
8. In the Queries pane, select the query you want to apply the parameter to.
9. Click on "Add Column" in the Home tab and select "Custom Column".
10. In the Custom Column dialog box, enter the following formula: = GoogleAnalytics.Account("Your Account ID", "Your Property ID", [Start Date Parameter], [End Date Parameter])
11. Replace "Your Account ID" and "Your Property ID" with your own GA4 account and property IDs.
12. Replace [Start Date Parameter] and [End Date Parameter] with the names of the parameters you created in step 5.
13. Click on "OK" to create the custom column.
14. Click on "Close & Apply" in the Home tab to apply the changes to your query.
Best regards.
Community Support Team_Caitlyn