Workaround for PowerBI Navigator record limit
Philip Robbins
✭✭✭✭✭
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
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives