How to use TOM libraries reliably (xmla) for Power BI datasets

Hi dbeavon3 ,

Here are some suggestions to help you.

1. Make sure your authentication token is valid and not expired according to error code 401. Sometimes, tokens can expire or become invalid, which can lead to unauthorized errors. Verify that the service principal or user account has the necessary permissions to access the dataset.

2. Consider upgrading Power BI capacity to higher SKUs to ensure adequate resources are available. Optimize datasets and queries to reduce memory consumption. Also, ensure that the network connection is stable and there are no intermittent connectivity issues.

While the Enhanced Refresh API may lack certain features, consider using it for operations where it is sufficient. It can provide a more stable alternative for certain tasks.

Here are some more related links that I hope will be helpful.

Handling errors in the TOM API (AMO-TOM) | Microsoft Learn

Troubleshoot XMLA endpoint connectivity in Power BI - Power BI | Microsoft Learn

Enhanced refresh with the Power BI REST API - Power BI | Microsoft Learn

Datasets - Refresh Dataset In Group - REST API (Power BI Power BI REST APIs) | Microsoft Learn

Best Regards,

Clara Gong

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