Issue with Active Directory when I set up schedule Refresh in Power BI Service

Hi, vnkesa123 

Problem: Data is truncated
Cause: Data source query limit has been exceeded
Some data sources, like Azure Data Explorer, Log Analytics, and Application Insights have a limit of 64 MB (compressed) on data that can be returned for an external query. Azure Data Explorer may return an explicit error, but for others like Log Analytics and Application Insights, the data returned is truncated.

Solution: Specify smaller refresh and store periods
Specify smaller refresh and store periods in the policy. For example, if you specified a refresh period of one year, and a query error is returned or data returned is truncated, try a refresh period of 12 months. You'll want to ensure queries for the current refresh partition or any historical partitions based on the Refresh and Store periods do not return more than 64 MB of data.

Here is the related document, hope it can help you.

https://docs.microsoft.com/power-bi/connect-data/incremental-refresh-troubleshoot 

https://docs.microsoft.com/power-bi/connect-data/refresh-troubleshooting-refresh-scenarios 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi, vnkesa123 

Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

Best Regards