Forum Replies Created
-
Posts
-
Try setting the RefreshEachConnection setting to False
Please try installing .NET Framework 4.6.2:
https://www.microsoft.com/en-US/download/details.aspx?id=53344
If it’s a large workbook try setting WaitBeforeRefresh (ms) in c:\Program Files\PowerPlanner\Power Update\PQRefresh.exe.config to a few minutes (120000-300000).The problem was probably that a dropbox link was used on the blogpost. We’ve reported the false positive issue to Symantec and they have removed the warning, so it should be ok after the definitions are updated. There’s also direct link here
Try Advanced Properties\Settings\Stop task if runs longer than x minutes, If the task fails restart every x minutes, If the running task doesn’t stop when requested, force it to stop. Also set Options\Disable Parallel Tasks
If you update to the latest version by re-downloading the setup, it should take care of the Privacy window.
You need to enable Options\Diagnostic Mode for this feature to work.Hi Avi,
I think you can disable security/privacy prompts in Excel\PowerQuery\Options\Security\Require user approval for new native database queries and Excel\PowerQuery\Options\Privacy\Ignore Privacy levels. If you still get prompts after that please post a screenshot of them and we’ll try to handle them.
The feature works in our test environments.
To diagnose the problem, please update to the latest version by re-downloading and set ScritptRoles to True in C:\Program Files\PowerPlanner\Power Update\PQRefresh.exe.config and check if the C:\Users\B\AppData\Local\Temp\Power Update\roles.xmla file is generated during the update with the proper roles in it.You can create the table in SQL and set up the desired column data types and disable the Re Create option in Power SQL Update (columns are then matched based upon name).
The update should refresh the pivots before the Export to PDF is done, but there could be some async operation that still doesn’t finish when it get’s to the PDF export part, please try to increase the WaitAfterRefresh (ms) setting in PQRefresh.exe.config and check if that resolves the issue.
Have you tried PERSONAL.XLSB!Macro1 ?
Although there’s no overall timeout for refreshing the workbook, there’s a timeout for finding labels and buttons on the UI, which might cause the problem.
Can you try increasing the RetryCount and WaitUIRetry settings in C:\Program Files\PowerPlanner\Power Update\PQRefresh.exe.config
Is Power Update using UI Automation to refresh your workbook (if yes what’s the last open window before Excel closes)?
What error message do you receive in View History?
What version of Power Update are you using (Control Panel\Programs\Power Update\Version)?
If the issue is occasional, you could try setting the Retry Count and Retry Wait settings in the Advanced Settings page of the update task wizard.
Please update again, the latest version should be 1.1.361
If you update to the latest version by re-running pusetup.exe the issue will get fixed.
