cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
heidibb Member
Member

Data refresh not working on Google Sheet source

Hello,

 

I have a data source that is connected to a google sheet. I connected originally through the WEB option usin the sheet's shareable link. I have been working with it for a while now and have not had any issues with refreshing it using the "refresh" button.

 

Today, when refreshing, I am getting no new data. I have confirmed there are new rows in the source, but they are not coming through when refreshing.

 

Any thoughts? Is there a limit to the # of rows it will read from a google sheet?

2 REPLIES 2
heidibb Member
Member

Re: Data refresh not working on Google Sheet source

So, I found a solution I think on another message board (Qlik), and I tested it out in Power BI and it pulls in all rows. It seems as though connecting like I did originally limits to 100 rows. I tested importing a new source using the link format suggested in the Qlik post did pull in all rows (https://community.qlik.com/thread/160989).

 

BUT, now a follow-up question... can I somehow change the source link in my original source to avoid having to re-import and recreate all the transforms and calculations that I've done on my original data??

Sean Super Contributor
Super Contributor

Re: Data refresh not working on Google Sheet source

In the Query Editor - select your table - on the right side under Query Settings select the 1st Applied Steps Source - double click

 

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (4,649)