Forum Discussion

vnkesa123's avatar
vnkesa123
Icon for Microsoft Employee rankMicrosoft Employee
4 years ago

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

 

I have created a report within Power BI Desktop that uses Active Directory Data .

 

I shared this report via "Publish" to app.powerbi.com and shared it with other coworkers.

 

Now when I was thinking I could set it up for automatic scheduled refresh that app.powerbi.com would automatically query AD regularly and update the report.

 

I am getting below error message.

Active Directory: An unexpected error occurred when querying Active Directory: 'This operation returned because the timeout period expired.

 

Can any one help me to resolve this issue?

Need Help

5 Replies

  • Hariharan_R's avatar
    Hariharan_R
    Icon for Solution Sage rankSolution Sage
    4 years ago

    Hi,

     Have you tried refresh your data in Power BI Desktop? Did it refreshed successfully? 

     

    If yes then try refresh one more time in the Power BI service with the same credentials (pass it in dataset settings)

     

    Thanks

    Hari

  • vnkesa123's avatar
    vnkesa123
    Icon for Microsoft Employee rankMicrosoft Employee
    4 years ago

    Hi Hari,

    Thanks for your response. Yes, from desktop I have refreshed the tables and it worked. Now I have checked in Power BI Service to refresh the dataset again I can see some other error as shown in below.

    Last refresh failed: Wed Mar 09 2022 17:26:51 GMT+0530 (India Standard Time)
    The refresh operation failed because it took too long to complete. Consider reducing the size of your dataset or breaking it up into smaller datasets

    But my dataset size is 64 MB only.

    Could you please help me how to resolve this?

    Regards,

    Naresh Kumar

    • v-zhangti's avatar
      v-zhangti
      Icon for Community Support rankCommunity Support
      4 years ago

      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.

    • v-zhangti's avatar
      v-zhangti
      Icon for Community Support rankCommunity Support
      4 years ago

      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

      • vnkesa123's avatar
        vnkesa123
        Icon for Microsoft Employee rankMicrosoft Employee
        4 years ago

        Hi,

         

        Still the issue is not yet resolved.