Troubleshooting

Stuck on something? This page has the most common issues and their fixes. If you do not find your problem here, open the Logs page and filter by "Failed". You can also check the FAQ.

Connection and Sign-in Issues

"Connection failed" on Test Connection

This is the most common error. Here is how to fix it fast.

Error: AADSTS50011: Redirect URI does not match

This one is easy to fix. The Redirect URI in Azure must match the wizard URL exactly. Here is what it should look like:

https://your-domain.com/wp-admin/admin.php?page=wkpbic-setup-wizard&step=3

Watch out for these traps:

• It must start with https://, not http://.
• No trailing slash differences.
• No URL encoding differences (& vs &).

Head to Azure → App registration → Authentication → Web → Redirect URIs and paste the exact URL.

Error: AADSTS7000215: Invalid client secret

You pasted the Secret ID instead of the Secret Value. Go back to Azure → Certificates & secrets. Copy from the Value column, not the Secret ID column.

Error: AADSTS700016: Application not found

Your Tenant ID is wrong. Make sure you copied the Directory (tenant) ID from the Overview page. Do not confuse it with the Object ID.

"Auto-connect failed" after saving credentials

ROPC needs three things to work:

1. Azure → Authentication → Allow public client flows must be Yes.
2. The Microsoft account must not have MFA on.
3. The password in Settings → Authentication must be correct.

Tip: Use a dedicated service account with no MFA for ROPC.

My Token Keeps Expiring

Tokens from interactive OAuth only last about an hour. After that, you need to sign in again. Here are your options:

• Turn on ROPC (see above) for silent refresh.
• Switch to Manual mode and trigger sync via WP-CLI from a system cron.

Sync Issues

Sync Stalls or Times Out

This usually means a big dataset is hitting the PHP execution limit. Try these fixes:

• Raise max_execution_time in php.ini to 300 or more.
• Lower the batch size in Settings → Sync (for example, from 500 to 200).
• Create Load Profiles with date range filters to break the sync into chunks.

"Dataset not found" Error

Someone deleted the dataset in Power BI, but the plugin still points to it. Open Datasets and click Refresh. Then re-publish or create a new dataset.

Incremental Sync Is Missing New Rows

Incremental sync uses the date_modified field to spot changes. So check these:

• Does your entity even have a date_modified field? (Orders, Products, and Customers do.)
• Is the field actually updating? Some custom code disables it.
• Try Reset Watermark on the Sync page to force a full re-scan.

An Entity Is Missing from Sync

• Open Workspaces, Datasets & Tables and check the entity is part of a published dataset.
• In the Setup Wizard Step 5, confirm you ticked the entity.

Rate-Limited by Power BI

Power BI limits requests per workspace. Usually it is about 120 per minute. If you hit the limit, try this:

• Lower batch size or frequency.
• Split your syncs across more than one workspace.
• Upgrade to Premium for higher quotas.

HPOS and WooCommerce

"HPOS compatibility warning" on Activation

HPOS is required. Here is how to turn it on:

1. Open WooCommerce → Settings → Advanced → Features.
2. Enable High-performance order storage.
3. Run the WC data sync if it prompts you.
4. Reload the plugin page.

Orders Entity Is Empty

Either HPOS is off, or your store has no orders in the statuses the plugin looks for. Check the Sync page filters and the data in the wp_wc_orders table.

Multi-Store Issues

Remote Store Returns 401

• The Consumer Key or Secret was revoked on the remote store.
• The API key does not have Read permission.
• Make new keys on the remote store and paste them again.
• Some security plugins (like Wordfence) block REST API calls — whitelist your server IP.

"Connection failed. Check URL and credentials."

Walk through this list:

• Does the Remote Store URL include https://?
• Can this server reach the remote? Try curl https://remote.example.com.
• Did you paste the keys with extra whitespace? Trim them.

Remote Data Does Not Appear in Power BI

• Check that Enable Remote Store is on.
• At least one Load Profile must have Data Source = Remote.
• Check Logs for remote fetch errors.

Admin Area Issues

Plugin Pages Show a Blank White Screen

Try these in order:

• Check the PHP error log (wp-content/debug.log if WP_DEBUG_LOG is on).
• Confirm PHP is 7.4 or higher.
• Deactivate other plugins to spot a conflict.
• Switch to a default theme like Twenty Twenty-Four for a minute.

JavaScript Errors on Dashboard or Query Builder

• Hard-reload your browser (Ctrl+Shift+R).
• Open devtools → Console and read the error.
• Make sure the built JS files exist under wp-content/plugins/woocommerce-power-bi-connector/assets/js/dist/.
• If you are on a dev build, run npm run build to rebuild them.

Settings Will Not Save

• Clear any object cache (Redis or Memcached).
• Check the wp_options table is writable.
• Log out and back in — nonce errors mean your session expired.
• Security plugins sometimes strip POST fields. Test with them off.

Credentials Show as Dots but the Connection Fails

Do not submit the masked dots. Type the real values and click save.

Embedding Issues

"You don't have access to view this report"

The Power BI user you are signed in as does not have access to the workspace. Share the workspace or report in Power BI Service.

Embedded iframe Is Blank

• Open devtools. Do you see a CSP error? Whitelist *.powerbi.com and *.microsoft.com.
• Is the iframe blocked by X-Frame-Options? Check your Nginx or Apache config.

Shortcode Shows "Please sign in"

The current user is missing the wkpbic_view_reports capability. Grant it in Access Control.

Handy Diagnostic Commands

# Plugin version and status
wp plugin list --name=woocommerce-power-bi-connector

# Connection status
wp wkpbic status

# Full validation
wp wkpbic test-connection

# Recent errors
wp wkpbic logs --status=failed --limit=10

# Scheduled cron jobs
wp cron event list | grep wkpbic

# Force a cron run now
wp cron event run wkpbic_scheduled_sync

# Clear all caches
wp wkpbic flush-cache

# List all plugin options
wp option list --search="wkpbic_*"

# Run Action Scheduler queue
wp action-scheduler run

Still Stuck?

• Open Logs, filter by Failed, and click a row to see the full error and API trace.
• Read the FAQ.
• Contact Webkul support at https://webkul.uvdesk.com/. Please include:
  • Plugin version
  • WordPress and WooCommerce versions
  • PHP version
  • The failing log entry (redact your keys first)