Forum Discussion
Data Refresh
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.
5 Replies
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
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🤔
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.
Is there no one to help me?🙄
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
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.
