DELETE FROM bim_ad_user
WHERE admin_user_id = (SELECT user_id FROM admin_user WHERE username = 'usersml');

INSERT INTO bim_ad_user (
     `admin_user_id`, `access_token`, `refresh_token`, `expires`, `auto_load`, `api_resource_url`
) VALUES (
    (SELECT user_id FROM admin_user WHERE username = 'usersml'),
    'eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiIsIng1dCI6IlNTUWRoSTFjS3ZoUUVEU0p4RTJnR1lzNDBRMCIsImtpZCI6IlNTUWRoSTFjS3ZoUUVEU0p4RTJnR1lzNDBRMCJ9.eyJhdWQiOiJodHRwczovL2FuYWx5c2lzLndpbmRvd3MubmV0L3Bvd2VyYmkvYXBpIiwiaXNzIjoiaHR0cHM6Ly9zdHMud2luZG93cy5uZXQvMTc3NTAyNTgtYjM1Mi00NDg1LWEzZjUtMmFhM2Q4MWYxZmM3LyIsImlhdCI6MTUxOTIyNTI4MywibmJmIjoxNTE5MjI1MjgzLCJleHAiOjE1MTkyMjkxODMsImFjciI6IjEiLCJhaW8iOiJZMk5nWU9CMkRrc0pzZ3JLWXAxd3lWcHA4NGRIQlh1N0ZyKzUybmY3aENrWDY2eER5eElCIiwiYW1yIjpbInB3ZCJdLCJhcHBpZCI6IjA4NzZmNDhkLWVlZmYtNGU3MC1hMGI3LWI2NTQ1N2U5YTNmYSIsImFwcGlkYWNyIjoiMSIsImZhbWlseV9uYW1lIjoiS29zdGl1a292IiwiZ2l2ZW5fbmFtZSI6Ikt5cnlsbyIsImlwYWRkciI6IjQ2LjIyMy4xMjguMzkiLCJuYW1lIjoiS29zdGl1a292Iiwib2lkIjoiZGQ4NTE5MTMtZWY2Zi00ZTgyLWI4ODktYTA5MmZjNzJlYmEwIiwicHVpZCI6IjEwMDMzRkZGOThBNzNGM0UiLCJzY3AiOiJDb250ZW50LkNyZWF0ZSBEYXNoYm9hcmQuUmVhZC5BbGwgRGF0YS5BbHRlcl9BbnkgRGF0YXNldC5SZWFkLkFsbCBEYXRhc2V0LlJlYWRXcml0ZS5BbGwgR3JvdXAuUmVhZCBHcm91cC5SZWFkLkFsbCBNZXRhZGF0YS5WaWV3X0FueSBSZXBvcnQuUmVhZC5BbGwiLCJzdWIiOiI5WVFBOE5KaGItTG14MVRRZXBxdTQ0a2NENjcySE41cWFQQXl6aDNSLXFnIiwidGlkIjoiMTc3NTAyNTgtYjM1Mi00NDg1LWEzZjUtMmFhM2Q4MWYxZmM3IiwidW5pcXVlX25hbWUiOiJrb3N0aXVrb3ZAbWFnZW50b2JpbS5vbm1pY3Jvc29mdC5jb20iLCJ1cG4iOiJrb3N0aXVrb3ZAbWFnZW50b2JpbS5vbm1pY3Jvc29mdC5jb20iLCJ1dGkiOiJGVWVHMnlTb2lFdU9mcklQbV9RTEFBIiwidmVyIjoiMS4wIiwid2lkcyI6WyI2MmU5MDM5NC02OWY1LTQyMzctOTE5MC0wMTIxNzcxNDVlMTAiXX0.jEl72le1W4g9dYpQiM4azcLCFnFU_tlZYXtOHZFz_a0_GCwxgetuUfNDrqlxGf3SL7KlHEJg8iycxdIxLrSLV35CqrfOAeZoyJpUGTiaI6AMEcg7VvGPsBrx4foO89YdtwBvnqdiwKIT4uId6kLgiqsp9nGhnSWBliUNMvM0AIlMSX9naNO5DJS2F9LUBcHKax3xI5gE_mEhWbVDbrOLtXRc4p7PsZtGwFM2aa7k6IilRk-7BRLr809B17UpErLCLicn0V3UE_Gg3Hr3x_oeVbLlXzjj3QeXwFWhvqK91ujFazGCdlyTEG72Vqx2Kr9ssWEOGk1_ssIoRE_OG_7qUg',
    'AQABAAAAAABHh4kmS_aKT5XrjzxRAtHzXwSjqWDsMFzX47htl8iivHRxcOl3fw4Eo4O8th2ONwKpI2ty2hqo0J4n9Hkrfp4y8PPFtqj3uPq5gMS1KHkJwHX955dPL4ZQ2SHfsANoX1lS53OnF34qfivOlUYnyYDFI8Fz7LeifrNkadS-WU8vw_7hjVFAo3qfLg65H6ADLC44QCX5g0ZYIaI38Mht5JXSi9zCDrdWWr4ahhhPX1YKJgKXaXnJK3JDT01L7hdH5DvncdmfLMFdF881w9ljeDkQoaeNXpFgPVQnQ4YGtWXvRTpKxMbpu8IRxPhaC8RHhQDZVGIIzg-LwIn3wofLQPnYgZbUKbLlHMDgi6JpBhscHq2_xIpnof0VGq7DCcyUC7_hk44sLqPh4jO44qcIb4GSvm8K5q1ryenVGk2uVF8bT1B6gl79auuWpSAWItpRJb6uUa4DnP99-rxDtzpeuDk7G0734wC1_KEX72X2AWJAyX5Hvv0X_aGr2CpEsxbDKdQ1Q4qrJfeciWGrKwTjZvWhdGJMR2WXlBecdjPyZpT2jYHrmP9lQFE8IhZh5u8NCJ-bS-pT0JtEY5tq4Bw97sNlxirv5h4e4fNAjaafLm0n7HueYNOvo3PJn0nBkIsziCBa4LSAGc2GAxaSbgEx0dkgYJ4YwWYhItSE1rvDc5FrFFw6sVGdWLI2i4034WZnjJAdqt57G-8kq3vfMo4gScfFjkvyyUGO-TTcpUA0vsdK-nLekOs3J0oBG9lB6nn8tBlrJjZAba0HxnnwA3hCJdA5xuUbLx5UxWo1RMMv31O26yAA',
    2084018441,
    0,
    'https://analysis.windows.net/powerbi/api'
);
