Workaround for PowerBI Navigator record limit

Philip Robbins
Community Champion
Problem statement:
When looking to utilise PowerBI via the Live Data Connector I was unable to find the sheets I wanted to connect.
Cause:
The PowerBI Navigator will return a maximum of 10,000 records from a given source.
Workaround:
I've managed to work around this by setting up a second DSN connection for the Live Data Connector using an alias Google account that has a Smartsheet licence assigned to it. This one I use for demos mostly and it's shared to far fewer sheets than my main account, so doesn't hit the limit. This way I've been able to access the sheet I want and connect it to PowerBI.
Phil Robbins
Tags:
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 431 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives