cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

Issue with data source credentials Google Analytics

Hi all,

for a little while now I have an issue with my Google Analytics credentials on PBI service.

It shows "Your data source can't be refreshed because the credentials are invalid. Please update your credentials and try again.".

My credentials are valid though, since I am able to refresh the dataset manually.

 
 

Screenshot 2020-12-16 121852.png

 

 

As a consequence of this error, I cannot set up a scheduled refresh for the dataset (the area is greyed out).

Screenshot 2020-12-16 121938.png

 

I have tried with another Power Bi account in a different organization, same issue. I do not have any issue with source credentials nor scheduled refresh on other reports that do not have Google Analytics as a data source.

But all my reports that use the Google Analytics connector as a data source have this issue.

 

I have also tried to update my credentials, use another Google Analytics account, uninstalling/reinstalling Power Bi desktop... without success so far.

 

Any idea?

thanks a lot

1 ACCEPTED SOLUTION
Frequent Visitor

I fixed it, here is the solution:

  1. Download the latest update of PowerBi Desktop
  2. Refresh and connect everything locally and then update the file / publish
  3. Connecting now works, but you may have to use "Authentification Method: None" for Google Analytics.

It's the PowerBi Update that came out a few days ago.

View solution in original post

6 REPLIES 6
Microsoft
Microsoft

Hi @mpcbto ,

 

Does the method provided by @guitar___  solve your problem? 

If it is resolved, please kindly Accept it as the solution. More people will benefit from it.

 

 

 

Best Regards,

Stephen Tao

 

Frequent Visitor

I fixed it, here is the solution:

  1. Download the latest update of PowerBi Desktop
  2. Refresh and connect everything locally and then update the file / publish
  3. Connecting now works, but you may have to use "Authentification Method: None" for Google Analytics.

It's the PowerBi Update that came out a few days ago.

View solution in original post

Thanks @guitar___ 

I just got the latest update, will try your method

Best

 

Frequent Visitor

We have the same issue. Is exactly as stated by mpcbto, including the perfect refresh history without errors and no gateway used.

 

We can manually refresh in Desktop and Online, but we cannot reactivate the scheduled refresh (we had to add another person to the list of e-mail recipients).

 

We also tried multiple times, different times, etc. - it is not possible. Scheduled refresh stays greyed out even though all connectors are definitely validated with the correct credentials.

 

And to repeat again: scheduled refresh worked perfectly since months, but when I disabled "scheduled refresh" today for a second to add another e-mail, I now cannot enable it back on.

 

We did no changes to the underlying Google Analytics connector.

Microsoft
Microsoft

Hi @mpcbto ,

 

Could you please provide me with the screenshot by clicking the Refresh history in the Datasets setting. If there is a detailed report of the error, please provide it, thank you.

19.png

20.png

 

 

For now, you could troubleshooting by yourself through this link. Please check if the gateway is updated to the latest version and also check if the PBIEgwService is always running on your server.

 

 

 

Best Regards,

Stephen Tao

 

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

 

Hello @v-stephen-msft ,

thanks for the help here.

 

Here are the screenshots.

I'm not using any gateway as it says I don't need one. Moreover, I'm not sure on what PBIEgwService  is, but I guess it's enabled as I work for a very large organization with thousands of Power BI reports. Plus I have tried in another Microsoft organization and it did not work either.

 

thanks!

 

Screenshot 2020-12-18 083231.pngScreenshot 2020-12-18 083217.pngScreenshot 2020-12-18 083208.png

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Microsoft Ignite

Microsoft Ignite with Arun Ulag

Featured Session Drive Data Culture with Power BI: Vision, Strategy & Roadmap. Register here https://myignite.microsoft.com #MSIgnite #PowerPlatform #Power BI ​

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors