Auto Refresh Issue

[Rahp]

Issues:
Google sheet credntials email has editor rights 
the owner email id is different & the powerbi login id is also different. the whole rreport is ready but the refresh issue is their as schedule refresh is not working as if the data credentials tab is blur in powerbi service. Plus powerbi free desktp version.

end results want:
Auto refersh from google sheet to report link wihtout publishing the report 

[MattiaFratello · Accepted solution]

Hi @Rahp,

Power BI free accounts do not support scheduled refresh or gateway connections. You need a Power BI Pro or PPU (Premium Per User) license to:

• Schedule refreshes.

• Manage Google Sheets credentials properly.

Also, Google Sheets as a data source requires an OAuth token under the same account that publishes the report or has appropriate permissions to refresh.

[Shiva2210]

I have Power BI Pro access but need to fix this error

[Rahp]

Its Powerbi Pro Account 

[grazitti_sapna · Accepted solution]

Hi @Rahp 

1.Power BI Free users cannot schedule refreshes. You need Power BI Pro or Premium.
2.Power BI Service requires authentication to Google Sheets, and it only works when:

• The Google credentials are linked properly in the dataset settings.
• Power BI Service can access the sheet using an authorized connector.

3.If the Google Sheet is not public or shared properly, Power BI Service cannot access it.


🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!

[MattiaFratello · Accepted solution]

Hi @Rahp,

Power BI free accounts do not support scheduled refresh or gateway connections. You need a Power BI Pro or PPU (Premium Per User) license to:

• Schedule refreshes.

• Manage Google Sheets credentials properly.

Also, Google Sheets as a data source requires an OAuth token under the same account that publishes the report or has appropriate permissions to refresh.