Hi all, I am experiencing issues with the authentication of Google Analytics when using more than one dataset powered by GA. I have created the two datasets in Power BI Desktop, then published to my account. I then log into Power BI via my browser and try to set up scheduled refresh times for both GA datasets authenticating using OAuth2, selecting my Google account, then I get an error message saying "Failed to update data source credentials". I have no issues doing this with a single GA dataset.
I tried using a single dataset for all of my GA queries and reports, but am finding that the refresh time/overheads required on an ever-expanding dataset is just too much (I am only around 30% through building the dataset queries and reports and it takes over two hours to refresh the data). So splitting my queries and reports across multiple datasets is much preferable since any ad-hoc updates to queries can be refreshed quickly.
Curiously, if I make a copy of my original Power BI Desktop dataset file that I published and refreshes automatically successfully, then make the modifications I need to with the queries/reports, then rename and publish, it has gone live as a second dataset and both datasets refreshed automatically this morning. However, when I go to the schedule settings for both datasets this morning, I lose authentication permissions. Does Power BI Desktop have a place I can specify the auto refresh dates/times or does this have to be done within the browser app?
Does anybody have any experience with this kind of scenario who could help?
Matt
