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

https://www.prodactive.co.uk/

https://www.youtube.com/%40Smartsheetexpert