Forum Discussion
Anonymous
5 years agoNot applicable
Building a Google Adwords Query in Power BI
Hi Everyone, I am building an AdWords query in Power BI. The query contains all the dimensions and metrics I am looking for, but when I add the "search query" dimension, the data changes. Before ...
amitchandak
Super User
5 years agoAnonymous , I do not see any table or column with the name search query in the file. am I missing something
Anonymous
5 years agoNot applicable
amitchandak no you are not missing anything, I do not have the "search query" column in the keywords table because it throws off the totals in the table visual. I did leave permissions enabled for the google analytics connector, in case you wanted to add the "search query" dimension to the keywords table from the AdWords folder in the google analytics connector. Adding the "search query" dimension to the keywords table will cause the total values in the table visual to drop by about half