Data Refresh

[MahsaTMahsa]

Hi there

I have had an issue with refresh data in power bi since yesterday and everything was ok before yesterday.

when I want to refresh data, this error appears to me 👇

 I can't connect to excel files or also google analytics server.

there are no permission changes and also I clear the permission and submitted the permit again but the problem exists.

[v-yangliu-msft]

Hi  @MahsaTMahsa ,

This is the related document, you can view this content:

Solved: Access to resource is forbidden - Microsoft Power BI Community

Solved: Details: "Access to the resource is forbidden." - Microsoft Power BI Community

How to fix the "Access to the resource is forbidden" error? - Power BI Connector for Jira - Alpha Se...

Get Data from excel in Sharepoint "Access to the resource is - Microsoft Community

Best Regards,

Liu Yang

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

[MahsaTMahsa]

Is there no one to help me?🙄

[mahoneypat]

If you are sure you still have access, that looks like the credentials in the Data Source Settings need to be updates/refreshed. I would go to the Query Editor; if you see the error there, open Data Source Settings and clear/update the credentials for those queries.

Pat

[MahsaTMahsa]

Thanks for your kind reply.

I test the solution but the problem is persist.

I guess that there is a problem with conneting to google analytics. I tried to connect in new powerbi project file and the problem is persist🤔

[QueryWhiz]

Hi @MahsaTMahsa were you able to find a solution? As a workaround, maybe you can try to test your connection with a 3rd party connector. I've tried windsor.ai, supemetrics (which doesn't have PBI as a destination, so you first have to export to Google Sheets and then export to PBI) and funnel.io. I stayed with windsor because it is much cheaper so just to let you know other options. In case you wonder, to make the connection first search for the GA connector in the data sources list:

After that, just grant access to your GA account using your credentials, then on preview and destination page you will see a preview of your GA fields:

There just select the fields you need. Finally, just select PBI as your data destination and finally just copy and paste the url on PBI --> Get Data --> Web --> Paste the url.