Forum Discussion
Auto Refresh Issue
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
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.
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!
4 Replies
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.
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!Its Powerbi Pro Account
I have Power BI Pro access but need to fix this error
