Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Schedule Refresh - Salesforce Reports

Hi   Due to the Power BI and Salesforce limitation of a maximum of 2,000 rows per query, I have had to split a report into 8 seperate reports.   When I publish to my workspace and go to schedule ...
General Comment
Need Help
v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

Hi Anonymous 

When configuring data source under gateway and entering credential under schedule refresh setting,

Do you use an OAuth authenticate?

 

If so, an OAuth Refresh token should expire if it has been inactive for 90 days. 

So check if the dataset/reports is inactive for these days.

 

Or the Azure Active Directory (AAD) OAuth token, used by many different data sources, expires in approximately one hour.

This error will occur when loading data takes longer than the token expiration (more than one hour).

 

As for "Salesforce Reporting row number Limitations", please refer to this thread.

When using Salesforce Object connector in Power BI Desktop, it doesn’t have the 2000 row limit.

 

Best Regards
Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.