Forum Discussion

SandwichNo1's avatar
SandwichNo1
Copper Contributor
Jun 12, 2023

Power query excel web refresh issues

Hi, I have built an excel file in excel desktop app which uses power query and set up a power pivot using the data I have imported. I know when refreshing power query online the power query inputs need to come from tables within the workbook which I have done but I am still getting this error.

 

I am not sure what this means?

 

SergeiBaklan

jokahati 

 

Any Ideas? Thanks in advance.

 

Andy

 

Connection: Query - Cost Centre Mapping Table
Error: COM error: Microsoft.Sql.Analysis.ASOnPremisesDataAccess, Failed discovery for connection string provider=Microsoft.Mashup.OleDb.1;data source=$Workbook$;location="Cost Centre Mapping Table".
A connection could not be made to the data source with the DataSourceID of '4309651d-abc2-4a49-ba32-d2b0f731dbb1', Name of '<ccon>Query - Cost Centre Mapping Table</ccon>'.
An error occurred while processing table '<ccon>Cost Centre Mapping Table</ccon>'. (<ccon>Cost Centre Mapping Table</ccon>).
COM error: Microsoft.Sql.Analysis.ASOnPremisesDataAccess, Failed discovery for connection string provider=Microsoft.Mashup.OleDb.1;data source=$Workbook$;location=Output.
A connection could not be made to the data source with the DataSourceID of 'e3f9c5e8-8372-4054-a4e0-8ce5a157cc5d', Name of '<ccon>Query - Output</ccon>'.
An error occurred while processing table '<ccon>Output</ccon>'. (<ccon>Output</ccon>).
COM error: Microsoft.Sql.Analysis.ASOnPremisesDataAccess, Failed discovery for connection string provider=Microsoft.Mashup.OleDb.1;data source=$Workbook$;location="Subjective Mapping Table";extended properties="UEsDBBQAAgAIAJK+zFYEgg6ipwAAAPcAAAASABwAQ29uZmlnL1BhY2thZ2UueG1sIKIYACigFAAAAAAAAAAAAAAAAAAAAAAAAAAAAHu/e7+NfUVujkJZalFxZn6erZKhnoGSQnFJYl5KYk5+XqqtUl6+kr0dL5dNQGJydmJ6qgJQdV6xVUVxiq1SRklJgZW+fnl5uV65sV5+Ubq+kYGBoX6Er09wckZqbqISXHEmYcW6mXkga5NTlexswiCusTPSMzSw0LO0MNMzsNGHCdr4ZuYhFBgBHQySRRK0cS7NKSktSrVLzdN1d7LRh3Ft9KF+sAMAUEsDBBQAAgAIAJK+zFZTcjgsmwAAAOEAAAATABwAW0NvbnRlbnRfVHlwZXNdLnhtbCCiGAAooBQAAAAAAAAAAAAAAAAAAAAAAAAAAABtjj0OwjAMRq8SeW9dGBBCTRmAG3CBKLg/onGixkXlbAwciSuQtmtHf37Pn3+fb3meXK9eNMTOs4ZdXoAitv7RcaNhlDo7wrkq7+9AUSWUo4ZWJJwQo23JmZj7QJw2tR+ckTQODQZjn6Yh3BfFAa1nIZZM5htQlVeqzdiLuk0pXmuTDuqycnOVBqFJcIlx03BbfOhNx4uBy8PVH1BLAwQUAAIACADOg8xW390+sj4VAABWjwAAEwAcAEZvcm11bGFzL1NlY3Rpb24xLm0gohgAKKAUAAAAAAAAAAAAAAAAAAAAAAAAAAAA7T3ZbhtJku8G+h8SZaxBomlapCTbvT1qrERKFmd1jUi34VUTRqmYsmpcrOLUYVsQ9C8L7J/Ml21kZh15RBaLtHqmD/ZDW8wzIjKujIzMSqiX+lFIxuLf3o9PniS3bkxn5KkziJKUDGiYxpScuouFH350yB4JaPqEwH/jKIs9CgWHXz0adN9F8afrKPrUOvID2h1EYQo9k5Yz/s9fjvzQDT2a/+u7AQwXuh/pHFoUleSSLqI4LSZKfsn/IB6DwuNQdL8GyVen3SFhFgQdksYZbXc4LJPr4MP55f7g5PDDYPBhfEtpCoAJCO+vRimd7zlKG6fz334423N4U2f6cDV0U3cqBgPMb93wI9BgcregDOWJew04TWI3TG6ieD6Igmwessqkhczcub93RJOeA1BCM5LSr+lDhxTlfUv5tqV8x1K+ayl/aSl/ZSl/bSn/wVLe27JV2DDuqSg/tAtSX9J59JmROlqQy+hLUpF7/MlftLS16GyXHS/iaB6lUHFM3RmNpY55TV7eQubokKu80X4QjD03cONkj7HTtI2xQG8JDyDACB6o5GcQzShCGrUBGdLEM1oN/c9+ArJprSBf/PRWjAOidUkTGn+mCUkWgZ8anUbhwk19aEtewJzzeRb66R38fZ7e0hiBMF6QoR+DdohiaDUaD+H/p8dGw9NjNt756enbs9HkPRtvcnx4aTR7t385HNsReU7GC8oUhA+EOYijTzQkUWYiMQg4BgNQVORNHGULo8UYaOCDVjnxQ5PuY5qmTJmpHPnED9G1l1XiOLv+O9OUn/+dGjEpgbArxKdO0TplfCsUk2PoRKVRvU5cQd6wqVcUufUkTloej8nTDTQCFoCfMaelyQl6B5iHHIxszSvKkxmIauwvUkwwz47HxRCMDLcAoc5uQhRTGodcZJc15SNyFRFm82uOLtYCKGZtMM7mczf2EyDZ+Hww4nRjUz4nowtTUBm3xlFA0igFAEH26VcvyGZ0Zkp+vthAOnIAy8o4N+EGmJVgYwtN3pgYACFXcPsfaejdASALN8QAGUdzmBnHMiGtt6yMgcQm4ONfuN6npF2M44Z3NYsHQLybHJLzs5P3aAd5bWraFsDzUpMw+wPQocPR2Ru0ang4HlyOLiaj8zMT+dS9ueHKQShQ0OlcMSJ0Gj07FKKVE+uuwDHRoUUG1alfND3KYmZAiB96bBlAmQV3iW+MeDI5Oi01p4EjA8rNJP1GvFvqfYKGwB0vd7qMcRDXQSgGSSGJirzYcCFqJpKNgD56ZQbOs3SRpULvf4cp/kEWx6DIS/3fvr86c+d0T0zcZ6o1twbTznerKz8xm/AwQs9NSQCTZAtguwv3DpNkpc1g8D1ovYbN4A9wEP6RYb4Lb3/jx2Cq/TBJmeCrK1VrqQuOkH2goalTS1aslgpphXlUqK7H/bDD+SKI7iglbJVqarl4G/VAdMIMGiXP2AKQi8gHjJ8TT3ABoXn/xh1/dj0g5p1OArB4C6bDQLeYdD7KuFoRdbybUEaVMne91FJ94Ca+h5QfhrcEKRZsMWGGAak9c9nCgB4fhUkW40wxzhYh+S9Cejvd7df/gQzCBydsMTFs3MDLApfZ/lNA7Da4IyA88UeKtD3tYYV9rHAbK9zBCnexwpdY4Sus8DVW+AMK/BZaiuLUw5A6AreQvKduzHfR5kLsh2EGhD7IZh8pUv0zWFJuz9OIXFvanPbI/uzvOq+e9tHSbbR0By3dRUtfoqWv0NLXaOkPaGlvCy/Gseuh6J2BP6pYPDBVhXrfnzHxHGRJGs0r9Q6lQrEbRoowMRPOF1ebwl5S17sl/g25UjTWFMZzJqBmophZ8yS32g4BixwSrmZAXsv6cVlPg4Ty4dic0z3WMu8kSkQD8fczBwZxnl3hiniKY9rDUVWIAagOBpKzwnG8khR5ObXFVFjm7i+fmwmS8z80jsppKzU6/f5KVpvwk5nzsk6VLChQRAl+m7IjwQkbQvB2YTAt4kEDIC0ra+m4FAAyaKfkLz+RrWq0xn6QOi04Qhx3iUtXC3ro8zKPpCISpo78r2xwCnusF2Q/SfyP4ZxbyHBGZqDQiy7s78IBhQ3wEKs6hD5oxYXr2+ZXLahca5HU7eWiynmolZvsNgt8fAYSJ2zr6ye3DD2JpyV+ei7zGr4C/aUroMLK6L8MEhTp/SyN8sXM17IHM4u60sdl/6UlQEews/7ZDTLa0mGGjf6Q3rhZkIqxmIZiCkp4zc60LYbzw2pYjFvTTl6cF5zfsOFZ8b3wolhljk9MvSie5T9Y7OihDbMUMyDYySGdwocABnLRYM5RFMxo3GVBnNWDNyyE8osyRbl9UaSxh2qB3NMX/NO6EsoehN/pb/V2ey9F+AdMzYyodS97r6x1r3qv87BRCcmYRQpzMSbXd6BcA3/uA3ASUKxJKQAa6CABuefMm0GVaD8BT/fgrhyt5XShyd8yMJPj9I4tbfK5LXzGOe2Ww3T7zgMaE1ouD3ZEmGyU01QK4wFfjV2LTtY5HXiFME80YYJxAozXPXW/Gu2uxMTTNjB9rgryEsZuvLuxp+XhWFOjC2gsGn2XqfR8YymRcLnrgU8Ky/GGss0Kj8tw3s05UQtvlpvZ9upbc9UVwMA/LEImOjDlmKIF/9tAqRaZ+4JtnaEocFhUlP3LAqHs32Mf4Asdbj20/t2ir15ejKWXF2Pr5cVcenkxN7qQFs/KSiwmW9FtESoVy4hGb68wdKSVXdV16Tml+sIRZEJw44KjaXKPwo+GhqzxaypUET6qKhtxkAaERkhwKmjsR3wB1eCDFLJgv/bziBg5D9Xfky+R1lmLcNhjH+UgPflHnzNyKDbH1d6uKtr30ozv3auiwltlhe8nQ6kX+1V1YL/ktuoG8mFDD5Ue6x1tIJzKzFdJWNXfNTHT3V4TUWsLCRe9jUIGrNI6ukYkvVoPQpjRq/qYXslTapXGYJZKwW3WIGJtsLFhTFJmSrzGdjbeYDurRw0OfKLSS2h6GLfLN1MtZWfdeSkr3RAMGmqyWQVusvucM41JlTVDFlEh8XPy5oQf0jnmkso0hnZB3g4nkWW3piOmqyKDQk/xWaednfaa6QHmPq2GcW38bvFVtxv4qpIRfmqhvdgfbPH//vm/RNodyMDv4CTWAAIK6yF1PruTRgvwmT/TwEFH310estkR3CPOHqKY3MAmWoqNqXEjKVg1feb0nGqbfUpjRpu/ZaBTqcTrZ+CL09lfI1+fd9fRlwbWCk2REiPpzcXBw4PG+tVJGJuSOYLdE3qTwlaZxhWwpT2wJGTZfRgNTevsSpJJ07ySJmkb6PmPmpyh57j8q6e3ROV2LGJVuxiSlC2Fjvm9UjPOzD4wjhy6MGD68cmTK9nYsMDKKGSnkeClsshvnJI5t+TRDRSBgbspgxR31I2ftoKb9mH3DUDV77/obxNosdV7sbXzor/VBxMzlVJd+GCsE4fNi8IkCvwZP3dZCFeEYcAKWtB5u0N2OqTXJnOauuRqlFy4MYg+AM+4746nenS4Mtpz8rid3uaS/iPzYXKRFiLHaEwqrX36uvt4p6+CLwianyWxld6Mr7sy4f3Ww5XWaiozgT6CLXwFqxrSLzyTJclPtFE6aUEvI5DcKPhQ0KHGzX+QY9QNvQtLLOK+3ofwcu1a4z6IJg8r2gDTeTCShoQlMDPDJEOwJM3oQYV0RauA56StYhTQuWvzk3T/N+/WretihNgjMN35YbEAbklMAwXTKY+RysOxleDih2cHbvipOC6rPShbfWiRtbR0cJbAJ0vLInA9QJmH2GVh4eVF4N1Kxw7PB3ScTt4hVnoymRVEW+mAUgOq9MMw34uzueKAFSVihukap1d6qHA19qs4xXLetdZxV0kBVPNryqNn13pahtK9qdw0hTdAFF7ZUCqq2pWgOp74S4VU4DbMwLvyWEi6gnUIjosfeqmpDXtcTRTDKX4LMqBstYrcGG6qbEYqz7N6LpLruD3jK/mt5srMmXpMQ2XLyioW4EEnlDqfTCXoGEdBwA+RHuFo6iJww5DJxPfQMaaey9b14y/FLEJmEmmXtOK5UHFa9fiHQZi87iwV2HVOg1C/u99gi73T8Dhop9lx0Fo8boCNHqjYE7l/pTOhlTU9ktst42F4QH/ekyGUXW0RoZrDocYnNLV82fSIhoXAcOI0WN3usPESm0c3lhWR72tJV7SkW1nSRSzp7pV03Uq6YSVdqpLuUclXp+TbUvIFqeJvacbeTmG+f8MAVqumi67EEsY1kfoV/rUvjPS4FVgr9RfLXf6GC15lHrBRMwq9mNtukRvsGNmXVQM9Fyr157RJ8m9twhaDbH8eZUbqkOZ45sgbab5KAxz5Iz8B1AlyuLVKBoN+DMIS28Dz+uf/ga8jUENSsLSUvgrZ6So5OkY6o5jpqQFDkbaXD51nPGrn6LwUy7AxmZGRT6Twldck+NTc8Rhn85aKUbF+QcDvfsgHcOD8xeJaJB/gQ7FGvKGaa7pXDsBWsEM0oPZANDpEZ3u9EyoWeqNSKvQKTSj2NJTkBkwoqvpCLBgAFRuY/SuuMOuK7EKjpqK12UkThKUNUHoogqIiNbWdDVkYVmG90vhXnJRzqpk6UXJKrfnV0jGIzGCmxkWULKZYrbpUUZ+IxjR1pK4SVR0oJ5CqChDReDYdp6k19JaJjni394dEffUDZpPdePqDAk+ebPCAp1g0yV3W4rr39Rd91s1I1E5h7zGzuezo35LrpScjiut6RIRjAL20PHe90hlIjczlJRr6uJu1vRRjLfnrHvNiHiHZYTvn0aS6QLXIRxc4l7IxfeZsOc+uNCim0lU/dWpbBIa0+m00CqMFaopxRb11tOqsRjmq2QR4NgGeTYBnE+DZBHg2AZ7fDoCbAM8mwPPoAZ6a23p/1NjPSrknSAwIOwL+A2YhWpPmHpq1KqDOdyH/tky+tS7W5kA32JGud2l05S3pCje7/2V70vroqX4BCaMkAtpvMqK6JHb6Z4itkrWCqwKjbwytMvWqK/O9YuoGusEAR2e6PVY+te5MNxHctcKYf7Ko7e8rUovu3owQjJxppcdqMY4zFgpbE4w4phmQd8FRPOOSgNCCVy1JCMtDNI0gaWaj1kkvNNHgZh+xzVhy4GrxXzNH8L7MEbTmSTbKPtTDv+ulHhap79+TIi7qRfNrP6QzPA+xeIWCt2ndL4vidpbn5K+Wg14EXStsO0YCpZTfyZx7vbKRW2+kZK7i0NeBc6/Wdoua1SyeBc7Cm8SmYH65nle97ks5XpU9uwSZdVSGpNlW1hUWG6xA1CibHFESy9LIV4FCZZqeZc9rJJmbu5Pf9XWLnmOb/Ne/b1ETQ/mV71jsWW5YJN96w2LPer9CG1p7MW3duyjGy2X8r25vfdL8Nq6fIBttqz7r1Sg0+42UxpqtIm6TfcbaMqGp3p7dFiAEwFTfN0Cy4o0DxbOykeuhziT1a22S4W2va5Mk6aizDCvewjFwWR7mlwCpdUAx8tQ/JVxrdpu759r01cJaiFd7h0R9st5yi2btC7Sb54ttJ0Sb54s3zxfzBpvniwXwm+eLN88Xo88Xs0a/4/eGZdurTl8Z3iI1MakxtOt+IMaS55fbbSExC9DITGqYH4p9JUYABFBavpbFbTH6PRhbJog1EaScpC7jYy1nEP0IzJvYRYykPQcjP7gREQfzuyllxw/mA17C5EWheH0lH92awdHiD9oE+QdF2GFNu6a5WcUNHRkzst0h2rI0Xb7ddF3QkB1XJUh3YbQ83GgdA2+AobqUclCMrjz9NmHUsFDiDMjG+XIhpwFL4wz9mxtw7ZnKvqbpFwqKoa65GK9YgsRYXLuD39y/V85qDE7BGWDpkkuL/Aj7wPLMpeLSCi4BO0aKhgmnyHawEDB9lg5RWRQPy6vzojuVM/olf8Wo5hGbzV5ls1fZ7FU2e5XNXmWzV9l8amXzqZXNp1aQj5k0P+XQs0JzW8y9WGDjNOP+boMvuKgfbZG/09LACmuWV7W1K1xeLexsYVg1S4qbTtNYqtax1hyaBsBQ+biSr9R6pcor9V2p7EpNV6q5UseVCq7UrqRqJfUqqdRcjUr88jZc+J/5jtrg8LyKu+91Z1KIg6s8gIW4xw08YqsTjD/xutbr8YU5QB60bJ53UcPmiJeKmh5ZSbNchf00jf3rTMiQyIuwX+FkDAkiAlssrkr4MSx+mxNbbW027IJnOUE1fqvltcneTySMUpErzQTVhUVq3TtbTrfr/MDw8Pjtz+I3/1HOJY65qp/9mqPamtO5RsToqPOunUePntrJKOifLV3zC1PiWpZ6w0SaZvoX/p5szlt5LqfF/jW5xbLtlPnE+VuN0IfHDHEMmjwJ3qtQqHIlFCR+4teoAfZ4CQq2q7r6I+EKCuLqbQ0SlpfH9du2JRKll8BcOhmPPWMpctewEH4e18j9QWfBERZFVn7fsfO79kK5zn4OkqgiX+VThF8K37Jyk8EZVbl0Kw9Cak0KgvfZ/QiZWk6R0FVcplgvY06D2fKe48bYrGVsOjqbdlQWteiwl7YL5kY+ITgfwC7cY/TDcg41g5OXTp9fSRNbjgdWe4viJdfP2PwW33nlryyUmvPKmCXfR1hfdt9WAqG6Blkj/JlXfMiHeLwwqAqazcSpzXqWN8/VVsqT5/oAyjMasplYhzh8gEcnjQKWjTA67AhV5CYKTZS+P3735DuJY6w3QNdiHhjtgxjtQ5EF+oiB9Ee5U42+ui9XLPl8hNppFC5gR8gY7gXMOZ+DKUjv2Cc02W4HgTBekKEfgxqABXlBRuMh/P/02Gh4eszGOz89fXs2mrxn402ODy+NZu/2L4djPcTV4PMWGlS2+H8Vlpc/fGFWpqkwCSayUQybXnLCvtxCdgCgEneaqiujHvko/KEyrDV/ex1+rQZ7fHY1csnjaM6/mFNkk2NnHzXJ53rzpGo+qzltOTseF0Oor5rrfFzzADoyIpcvYfrMk2/eAohkbQBe3NyNfRavGZ8PRvwUnk35nIwuTC7n0ZsoIMIFYczz1QuyGZ2ZYpNzBLtJfeAGPGSS8CwFVoKNnXtTTYkBEHLtILKjARCR/W4iGM1hZhzLhLTesjIGEpuAj3/hep+SdsPVAyjeTQ7J+dnJ++WrU9e4gJ8Xm7TZH4AOGo7O3qBVw8Px4HJ0MRmdn5n45/Fr0JpcA4FOrHxFjdjPDoVA5fS6K7BE2MYc1boCR1nMz4thv8HWws2/mKYry5PJ0al0YUEdYz9JKIsK4BIzGPOAPQvrWUc4cEOjc52q+39QSwECLQAUAAIACACSvsxWBIIOoqcAAAD3AAAAEgAAAAAAAAAAAAA.
A connection could not be made to the data source with the DataSourceID of 'e5dc5e63-ab2e-4a87-9615-da4a01f01023', Name of '<ccon>Query - Subjective Mapping Table</ccon>'.
An error occurred while processing table '<ccon>Subjective Mapping Table</ccon>'. (<ccon>Subjective Mapping Table</ccon>).
The current operation was cancelled because another operation in the transaction failed.

Connection: Query - Output
Error: COM error: Microsoft.Sql.Analysis.ASOnPremisesDataAccess, Failed discovery for connection string provider=Microsoft.Mashup.OleDb.1;data source=$Workbook$;location="Cost Centre Mapping Table".
A connection could not be made to the data source with the DataSourceID of '4309651d-abc2-4a49-ba32-d2b0f731dbb1', Name of '<ccon>Query - Cost Centre Mapping Table</ccon>'.
An error occurred while processing table '<ccon>Cost Centre Mapping Table</ccon>'. (<ccon>Cost Centre Mapping Table</ccon>).
COM error: Microsoft.Sql.Analysis.ASOnPremisesDataAccess, Failed discovery for connection string provider=Microsoft.Mashup.OleDb.1;data source=$Workbook$;location=Output.
A connection could not be made to the data source with the DataSourceID of 'e3f9c5e8-8372-4054-a4e0-8ce5a157cc5d', Name of '<ccon>Query - Output</ccon>'.
An error occurred while processing table '<ccon>Output</ccon>'. (<ccon>Output</ccon>).
COM error: Microsoft.Sql.Analysis.ASOnPremisesDataAccess, Failed discovery for connection string provider=Microsoft.Mashup.OleDb.1;data source=$Workbook$;location="Subjective Mapping Table";extended properties="UEsDBBQAAgAIAJK+zFYEgg6ipwAAAPcAAAASABwAQ29uZmlnL1BhY2thZ2UueG1sIKIYACigFAAAAAAAAAAAAAAAAAAAAAAAAAAAAHu/e7+NfUVujkJZalFxZn6erZKhnoGSQnFJYl5KYk5+XqqtUl6+kr0dL5dNQGJydmJ6qgJQdV6xVUVxiq1SRklJgZW+fnl5uV65sV5+Ubq+kYGBoX6Er09wckZqbqISXHEmYcW6mXkga5NTlexswiCusTPSMzSw0LO0MNMzsNGHCdr4ZuYhFBgBHQySRRK0cS7NKSktSrVLzdN1d7LRh3Ft9KF+sAMAUEsDBBQAAgAIAJK+zFZTcjgsmwAAAOEAAAATABwAW0NvbnRlbnRfVHlwZXNdLnhtbCCiGAAooBQAAAAAAAAAAAAAAAAAAAAAAAAAAABtjj0OwjAMRq8SeW9dGBBCTRmAG3CBKLg/onGixkXlbAwciSuQtmtHf37Pn3+fb3meXK9eNMTOs4ZdXoAitv7RcaNhlDo7wrkq7+9AUSWUo4ZWJJwQo23JmZj7QJw2tR+ckTQODQZjn6Yh3BfFAa1nIZZM5htQlVeqzdiLuk0pXmuTDuqycnOVBqFJcIlx03BbfOhNx4uBy8PVH1BLAwQUAAIACADOg8xW390+sj4VAABWjwAAEwAcAEZvcm11bGFzL1NlY3Rpb24xLm0gohgAKKAUAAAAAAAAAAAAAAAAAAAAAAAAAAAA7T3ZbhtJku8G+h8SZaxBomlapCTbvT1qrERKFmd1jUi34VUTRqmYsmpcrOLUYVsQ9C8L7J/Ml21kZh15RBaLtHqmD/ZDW8wzIjKujIzMSqiX+lFIxuLf3o9PniS3bkxn5KkziJKUDGiYxpScuouFH350yB4JaPqEwH/jKIs9CgWHXz0adN9F8afrKPrUOvID2h1EYQo9k5Yz/s9fjvzQDT2a/+u7AQwXuh/pHFoUleSSLqI4LSZKfsn/IB6DwuNQdL8GyVen3SFhFgQdksYZbXc4LJPr4MP55f7g5PDDYPBhfEtpCoAJCO+vRimd7zlKG6fz334423N4U2f6cDV0U3cqBgPMb93wI9BgcregDOWJew04TWI3TG6ieD6Igmwessqkhczcub93RJOeA1BCM5LSr+lDhxTlfUv5tqV8x1K+ayl/aSl/ZSl/bSn/wVLe27JV2DDuqSg/tAtSX9J59JmROlqQy+hLUpF7/MlftLS16GyXHS/iaB6lUHFM3RmNpY55TV7eQubokKu80X4QjD03cONkj7HTtI2xQG8JDyDACB6o5GcQzShCGrUBGdLEM1oN/c9+ArJprSBf/PRWjAOidUkTGn+mCUkWgZ8anUbhwk19aEtewJzzeRb66R38fZ7e0hiBMF6QoR+DdohiaDUaD+H/p8dGw9NjNt756enbs9HkPRtvcnx4aTR7t385HNsReU7GC8oUhA+EOYijTzQkUWYiMQg4BgNQVORNHGULo8UYaOCDVjnxQ5PuY5qmTJmpHPnED9G1l1XiOLv+O9OUn/+dGjEpgbArxKdO0TplfCsUk2PoRKVRvU5cQd6wqVcUufUkTloej8nTDTQCFoCfMaelyQl6B5iHHIxszSvKkxmIauwvUkwwz47HxRCMDLcAoc5uQhRTGodcZJc15SNyFRFm82uOLtYCKGZtMM7mczf2EyDZ+Hww4nRjUz4nowtTUBm3xlFA0igFAEH26VcvyGZ0Zkp+vthAOnIAy8o4N+EGmJVgYwtN3pgYACFXcPsfaejdASALN8QAGUdzmBnHMiGtt6yMgcQm4ONfuN6npF2M44Z3NYsHQLybHJLzs5P3aAd5bWraFsDzUpMw+wPQocPR2Ru0ang4HlyOLiaj8zMT+dS9ueHKQShQ0OlcMSJ0Gj07FKKVE+uuwDHRoUUG1alfND3KYmZAiB96bBlAmQV3iW+MeDI5Oi01p4EjA8rNJP1GvFvqfYKGwB0vd7qMcRDXQSgGSSGJirzYcCFqJpKNgD56ZQbOs3SRpULvf4cp/kEWx6DIS/3fvr86c+d0T0zcZ6o1twbTznerKz8xm/AwQs9NSQCTZAtguwv3DpNkpc1g8D1ovYbN4A9wEP6RYb4Lb3/jx2Cq/TBJmeCrK1VrqQuOkH2goalTS1aslgpphXlUqK7H/bDD+SKI7iglbJVqarl4G/VAdMIMGiXP2AKQi8gHjJ8TT3ABoXn/xh1/dj0g5p1OArB4C6bDQLeYdD7KuFoRdbybUEaVMne91FJ94Ca+h5QfhrcEKRZsMWGGAak9c9nCgB4fhUkW40wxzhYh+S9Cejvd7df/gQzCBydsMTFs3MDLApfZ/lNA7Da4IyA88UeKtD3tYYV9rHAbK9zBCnexwpdY4Sus8DVW+AMK/BZaiuLUw5A6AreQvKduzHfR5kLsh2EGhD7IZh8pUv0zWFJuz9OIXFvanPbI/uzvOq+e9tHSbbR0By3dRUtfoqWv0NLXaOkPaGlvCy/Gseuh6J2BP6pYPDBVhXrfnzHxHGRJGs0r9Q6lQrEbRoowMRPOF1ebwl5S17sl/g25UjTWFMZzJqBmophZ8yS32g4BixwSrmZAXsv6cVlPg4Ty4dic0z3WMu8kSkQD8fczBwZxnl3hiniKY9rDUVWIAagOBpKzwnG8khR5ObXFVFjm7i+fmwmS8z80jsppKzU6/f5KVpvwk5nzsk6VLChQRAl+m7IjwQkbQvB2YTAt4kEDIC0ra+m4FAAyaKfkLz+RrWq0xn6QOi04Qhx3iUtXC3ro8zKPpCISpo78r2xwCnusF2Q/SfyP4ZxbyHBGZqDQiy7s78IBhQ3wEKs6hD5oxYXr2+ZXLahca5HU7eWiynmolZvsNgt8fAYSJ2zr6ye3DD2JpyV+ei7zGr4C/aUroMLK6L8MEhTp/SyN8sXM17IHM4u60sdl/6UlQEews/7ZDTLa0mGGjf6Q3rhZkIqxmIZiCkp4zc60LYbzw2pYjFvTTl6cF5zfsOFZ8b3wolhljk9MvSie5T9Y7OihDbMUMyDYySGdwocABnLRYM5RFMxo3GVBnNWDNyyE8osyRbl9UaSxh2qB3NMX/NO6EsoehN/pb/V2ey9F+AdMzYyodS97r6x1r3qv87BRCcmYRQpzMSbXd6BcA3/uA3ASUKxJKQAa6CABuefMm0GVaD8BT/fgrhyt5XShyd8yMJPj9I4tbfK5LXzGOe2Ww3T7zgMaE1ouD3ZEmGyU01QK4wFfjV2LTtY5HXiFME80YYJxAozXPXW/Gu2uxMTTNjB9rgryEsZuvLuxp+XhWFOjC2gsGn2XqfR8YymRcLnrgU8Ky/GGss0Kj8tw3s05UQtvlpvZ9upbc9UVwMA/LEImOjDlmKIF/9tAqRaZ+4JtnaEocFhUlP3LAqHs32Mf4Asdbj20/t2ir15ejKWXF2Pr5cVcenkxN7qQFs/KSiwmW9FtESoVy4hGb68wdKSVXdV16Tml+sIRZEJw44KjaXKPwo+GhqzxaypUET6qKhtxkAaERkhwKmjsR3wB1eCDFLJgv/bziBg5D9Xfky+R1lmLcNhjH+UgPflHnzNyKDbH1d6uKtr30ozv3auiwltlhe8nQ6kX+1V1YL/ktuoG8mFDD5Ue6x1tIJzKzFdJWNXfNTHT3V4TUWsLCRe9jUIGrNI6ukYkvVoPQpjRq/qYXslTapXGYJZKwW3WIGJtsLFhTFJmSrzGdjbeYDurRw0OfKLSS2h6GLfLN1MtZWfdeSkr3RAMGmqyWQVusvucM41JlTVDFlEh8XPy5oQf0jnmkso0hnZB3g4nkWW3piOmqyKDQk/xWaednfaa6QHmPq2GcW38bvFVtxv4qpIRfmqhvdgfbPH//vm/RNodyMDv4CTWAAIK6yF1PruTRgvwmT/TwEFH310estkR3CPOHqKY3MAmWoqNqXEjKVg1feb0nGqbfUpjRpu/ZaBTqcTrZ+CL09lfI1+fd9fRlwbWCk2REiPpzcXBw4PG+tVJGJuSOYLdE3qTwlaZxhWwpT2wJGTZfRgNTevsSpJJ07ySJmkb6PmPmpyh57j8q6e3ROV2LGJVuxiSlC2Fjvm9UjPOzD4wjhy6MGD68cmTK9nYsMDKKGSnkeClsshvnJI5t+TRDRSBgbspgxR31I2ftoKb9mH3DUDV77/obxNosdV7sbXzor/VBxMzlVJd+GCsE4fNi8IkCvwZP3dZCFeEYcAKWtB5u0N2OqTXJnOauuRqlFy4MYg+AM+4746nenS4Mtpz8rid3uaS/iPzYXKRFiLHaEwqrX36uvt4p6+CLwianyWxld6Mr7sy4f3Ww5XWaiozgT6CLXwFqxrSLzyTJclPtFE6aUEvI5DcKPhQ0KHGzX+QY9QNvQtLLOK+3ofwcu1a4z6IJg8r2gDTeTCShoQlMDPDJEOwJM3oQYV0RauA56StYhTQuWvzk3T/N+/WretihNgjMN35YbEAbklMAwXTKY+RysOxleDih2cHbvipOC6rPShbfWiRtbR0cJbAJ0vLInA9QJmH2GVh4eVF4N1Kxw7PB3ScTt4hVnoymRVEW+mAUgOq9MMw34uzueKAFSVihukap1d6qHA19qs4xXLetdZxV0kBVPNryqNn13pahtK9qdw0hTdAFF7ZUCqq2pWgOp74S4VU4DbMwLvyWEi6gnUIjosfeqmpDXtcTRTDKX4LMqBstYrcGG6qbEYqz7N6LpLruD3jK/mt5srMmXpMQ2XLyioW4EEnlDqfTCXoGEdBwA+RHuFo6iJww5DJxPfQMaaey9b14y/FLEJmEmmXtOK5UHFa9fiHQZi87iwV2HVOg1C/u99gi73T8Dhop9lx0Fo8boCNHqjYE7l/pTOhlTU9ktst42F4QH/ekyGUXW0RoZrDocYnNLV82fSIhoXAcOI0WN3usPESm0c3lhWR72tJV7SkW1nSRSzp7pV03Uq6YSVdqpLuUclXp+TbUvIFqeJvacbeTmG+f8MAVqumi67EEsY1kfoV/rUvjPS4FVgr9RfLXf6GC15lHrBRMwq9mNtukRvsGNmXVQM9Fyr157RJ8m9twhaDbH8eZUbqkOZ45sgbab5KAxz5Iz8B1AlyuLVKBoN+DMIS28Dz+uf/ga8jUENSsLSUvgrZ6So5OkY6o5jpqQFDkbaXD51nPGrn6LwUy7AxmZGRT6Twldck+NTc8Rhn85aKUbF+QcDvfsgHcOD8xeJaJB/gQ7FGvKGaa7pXDsBWsEM0oPZANDpEZ3u9EyoWeqNSKvQKTSj2NJTkBkwoqvpCLBgAFRuY/SuuMOuK7EKjpqK12UkThKUNUHoogqIiNbWdDVkYVmG90vhXnJRzqpk6UXJKrfnV0jGIzGCmxkWULKZYrbpUUZ+IxjR1pK4SVR0oJ5CqChDReDYdp6k19JaJjni394dEffUDZpPdePqDAk+ebPCAp1g0yV3W4rr39Rd91s1I1E5h7zGzuezo35LrpScjiut6RIRjAL20PHe90hlIjczlJRr6uJu1vRRjLfnrHvNiHiHZYTvn0aS6QLXIRxc4l7IxfeZsOc+uNCim0lU/dWpbBIa0+m00CqMFaopxRb11tOqsRjmq2QR4NgGeTYBnE+DZBHg2AZ7fDoCbAM8mwPPoAZ6a23p/1NjPSrknSAwIOwL+A2YhWpPmHpq1KqDOdyH/tky+tS7W5kA32JGud2l05S3pCje7/2V70vroqX4BCaMkAtpvMqK6JHb6Z4itkrWCqwKjbwytMvWqK/O9YuoGusEAR2e6PVY+te5MNxHctcKYf7Ko7e8rUovu3owQjJxppcdqMY4zFgpbE4w4phmQd8FRPOOSgNCCVy1JCMtDNI0gaWaj1kkvNNHgZh+xzVhy4GrxXzNH8L7MEbTmSTbKPtTDv+ulHhap79+TIi7qRfNrP6QzPA+xeIWCt2ndL4vidpbn5K+Wg14EXStsO0YCpZTfyZx7vbKRW2+kZK7i0NeBc6/Wdoua1SyeBc7Cm8SmYH65nle97ks5XpU9uwSZdVSGpNlW1hUWG6xA1CibHFESy9LIV4FCZZqeZc9rJJmbu5Pf9XWLnmOb/Ne/b1ETQ/mV71jsWW5YJN96w2LPer9CG1p7MW3duyjGy2X8r25vfdL8Nq6fIBttqz7r1Sg0+42UxpqtIm6TfcbaMqGp3p7dFiAEwFTfN0Cy4o0DxbOykeuhziT1a22S4W2va5Mk6aizDCvewjFwWR7mlwCpdUAx8tQ/JVxrdpu759r01cJaiFd7h0R9st5yi2btC7Sb54ttJ0Sb54s3zxfzBpvniwXwm+eLN88Xo88Xs0a/4/eGZdurTl8Z3iI1MakxtOt+IMaS55fbbSExC9DITGqYH4p9JUYABFBavpbFbTH6PRhbJog1EaScpC7jYy1nEP0IzJvYRYykPQcjP7gREQfzuyllxw/mA17C5EWheH0lH92awdHiD9oE+QdF2GFNu6a5WcUNHRkzst0h2rI0Xb7ddF3QkB1XJUh3YbQ83GgdA2+AobqUclCMrjz9NmHUsFDiDMjG+XIhpwFL4wz9mxtw7ZnKvqbpFwqKoa65GK9YgsRYXLuD39y/V85qDE7BGWDpkkuL/Aj7wPLMpeLSCi4BO0aKhgmnyHawEDB9lg5RWRQPy6vzojuVM/olf8Wo5hGbzV5ls1fZ7FU2e5XNXmWzV9l8amXzqZXNp1aQj5k0P+XQs0JzW8y9WGDjNOP+boMvuKgfbZG/09LACmuWV7W1K1xeLexsYVg1S4qbTtNYqtax1hyaBsBQ+biSr9R6pcor9V2p7EpNV6q5UseVCq7UrqRqJfUqqdRcjUr88jZc+J/5jtrg8LyKu+91Z1KIg6s8gIW4xw08YqsTjD/xutbr8YU5QB60bJ53UcPmiJeKmh5ZSbNchf00jf3rTMiQyIuwX+FkDAkiAlssrkr4MSx+mxNbbW027IJnOUE1fqvltcneTySMUpErzQTVhUVq3TtbTrfr/MDw8Pjtz+I3/1HOJY65qp/9mqPamtO5RsToqPOunUePntrJKOifLV3zC1PiWpZ6w0SaZvoX/p5szlt5LqfF/jW5xbLtlPnE+VuN0IfHDHEMmjwJ3qtQqHIlFCR+4teoAfZ4CQq2q7r6I+EKCuLqbQ0SlpfH9du2JRKll8BcOhmPPWMpctewEH4e18j9QWfBERZFVn7fsfO79kK5zn4OkqgiX+VThF8K37Jyk8EZVbl0Kw9Cak0KgvfZ/QiZWk6R0FVcplgvY06D2fKe48bYrGVsOjqbdlQWteiwl7YL5kY+ITgfwC7cY/TDcg41g5OXTp9fSRNbjgdWe4viJdfP2PwW33nlryyUmvPKmCXfR1hfdt9WAqG6Blkj/JlXfMiHeLwwqAqazcSpzXqWN8/VVsqT5/oAyjMasplYhzh8gEcnjQKWjTA67AhV5CYKTZS+P3735DuJY6w3QNdiHhjtgxjtQ5EF+oiB9Ee5U42+ui9XLPl8hNppFC5gR8gY7gXMOZ+DKUjv2Cc02W4HgTBekKEfgxqABXlBRuMh/P/02Gh4eszGOz89fXs2mrxn402ODy+NZu/2L4djPcTV4PMWGlS2+H8Vlpc/fGFWpqkwCSayUQybXnLCvtxCdgCgEneaqiujHvko/KEyrDV/ex1+rQZ7fHY1csnjaM6/mFNkk2NnHzXJ53rzpGo+qzltOTseF0Oor5rrfFzzADoyIpcvYfrMk2/eAohkbQBe3NyNfRavGZ8PRvwUnk35nIwuTC7n0ZsoIMIFYczz1QuyGZ2ZYpNzBLtJfeAGPGSS8CwFVoKNnXtTTYkBEHLtILKjARCR/W4iGM1hZhzLhLTesjIGEpuAj3/hep+SdsPVAyjeTQ7J+dnJ++WrU9e4gJ8Xm7TZH4AOGo7O3qBVw8Px4HJ0MRmdn5n45/Fr0JpcA4FOrHxFjdjPDoVA5fS6K7BE2MYc1boCR1nMz4thv8HWws2/mKYry5PJ0al0YUEdYz9JKIsK4BIzGPOAPQvrWUc4cEOjc52q+39QSwECLQAUAAIACACSvsxWBIIOoqcAAAD3AAAAEgAAAAAAAAAAAAA.
A connection could not be made to the data source with the DataSourceID of 'e5dc5e63-ab2e-4a87-9615-da4a01f01023', Name of '<ccon>Query - Subjective Mapping Table</ccon>'.
An error occurred while processing table '<ccon>Subjective Mapping Table</ccon>'. (<ccon>Subjective Mapping Table</ccon>).
The current operation was cancelled because another operation in the transaction failed.

Connection: Query - Subjective Mapping Table
Error: COM error: Microsoft.Sql.Analysis.ASOnPremisesDataAccess, Failed discovery for connection string provider=Microsoft.Mashup.OleDb.1;data source=$Workbook$;location="Cost Centre Mapping Table".
A connection could not be made to the data source with the DataSourceID of '4309651d-abc2-4a49-ba32-d2b0f731dbb1', Name of '<ccon>Query - Cost Centre Mapping Table</ccon>'.
An error occurred while processing table '<ccon>Cost Centre Mapping Table</ccon>'. (<ccon>Cost Centre Mapping Table</ccon>).
COM error: Microsoft.Sql.Analysis.ASOnPremisesDataAccess, Failed discovery for connection string provider=Microsoft.Mashup.OleDb.1;data source=$Workbook$;location=Output.
A connection could not be made to the data source with the DataSourceID of 'e3f9c5e8-8372-4054-a4e0-8ce5a157cc5d', Name of '<ccon>Query - Output</ccon>'.
An error occurred while processing table '<ccon>Output</ccon>'. (<ccon>Output</ccon>).
COM error: Microsoft.Sql.Analysis.ASOnPremisesDataAccess, Failed discovery for connection string provider=Microsoft.Mashup.OleDb.1;data source=$Workbook$;location="Subjective Mapping Table";extended properties="UEsDBBQAAgAIAJK+zFYEgg6ipwAAAPcAAAASABwAQ29uZmlnL1BhY2thZ2UueG1sIKIYACigFAAAAAAAAAAAAAAAAAAAAAAAAAAAAHu/e7+NfUVujkJZalFxZn6erZKhnoGSQnFJYl5KYk5+XqqtUl6+kr0dL5dNQGJydmJ6qgJQdV6xVUVxiq1SRklJgZW+fnl5uV65sV5+Ubq+kYGBoX6Er09wckZqbqISXHEmYcW6mXkga5NTlexswiCusTPSMzSw0LO0MNMzsNGHCdr4ZuYhFBgBHQySRRK0cS7NKSktSrVLzdN1d7LRh3Ft9KF+sAMAUEsDBBQAAgAIAJK+zFZTcjgsmwAAAOEAAAATABwAW0NvbnRlbnRfVHlwZXNdLnhtbCCiGAAooBQAAAAAAAAAAAAAAAAAAAAAAAAAAABtjj0OwjAMRq8SeW9dGBBCTRmAG3CBKLg/onGixkXlbAwciSuQtmtHf37Pn3+fb3meXK9eNMTOs4ZdXoAitv7RcaNhlDo7wrkq7+9AUSWUo4ZWJJwQo23JmZj7QJw2tR+ckTQODQZjn6Yh3BfFAa1nIZZM5htQlVeqzdiLuk0pXmuTDuqycnOVBqFJcIlx03BbfOhNx4uBy8PVH1BLAwQUAAIACADOg8xW390+sj4VAABWjwAAEwAcAEZvcm11bGFzL1NlY3Rpb24xLm0gohgAKKAUAAAAAAAAAAAAAAAAAAAAAAAAAAAA7T3ZbhtJku8G+h8SZaxBomlapCTbvT1qrERKFmd1jUi34VUTRqmYsmpcrOLUYVsQ9C8L7J/Ml21kZh15RBaLtHqmD/ZDW8wzIjKujIzMSqiX+lFIxuLf3o9PniS3bkxn5KkziJKUDGiYxpScuouFH350yB4JaPqEwH/jKIs9CgWHXz0adN9F8afrKPrUOvID2h1EYQo9k5Yz/s9fjvzQDT2a/+u7AQwXuh/pHFoUleSSLqI4LSZKfsn/IB6DwuNQdL8GyVen3SFhFgQdksYZbXc4LJPr4MP55f7g5PDDYPBhfEtpCoAJCO+vRimd7zlKG6fz334423N4U2f6cDV0U3cqBgPMb93wI9BgcregDOWJew04TWI3TG6ieD6Igmwessqkhczcub93RJOeA1BCM5LSr+lDhxTlfUv5tqV8x1K+ayl/aSl/ZSl/bSn/wVLe27JV2DDuqSg/tAtSX9J59JmROlqQy+hLUpF7/MlftLS16GyXHS/iaB6lUHFM3RmNpY55TV7eQubokKu80X4QjD03cONkj7HTtI2xQG8JDyDACB6o5GcQzShCGrUBGdLEM1oN/c9+ArJprSBf/PRWjAOidUkTGn+mCUkWgZ8anUbhwk19aEtewJzzeRb66R38fZ7e0hiBMF6QoR+DdohiaDUaD+H/p8dGw9NjNt756enbs9HkPRtvcnx4aTR7t385HNsReU7GC8oUhA+EOYijTzQkUWYiMQg4BgNQVORNHGULo8UYaOCDVjnxQ5PuY5qmTJmpHPnED9G1l1XiOLv+O9OUn/+dGjEpgbArxKdO0TplfCsUk2PoRKVRvU5cQd6wqVcUufUkTloej8nTDTQCFoCfMaelyQl6B5iHHIxszSvKkxmIauwvUkwwz47HxRCMDLcAoc5uQhRTGodcZJc15SNyFRFm82uOLtYCKGZtMM7mczf2EyDZ+Hww4nRjUz4nowtTUBm3xlFA0igFAEH26VcvyGZ0Zkp+vthAOnIAy8o4N+EGmJVgYwtN3pgYACFXcPsfaejdASALN8QAGUdzmBnHMiGtt6yMgcQm4ONfuN6npF2M44Z3NYsHQLybHJLzs5P3aAd5bWraFsDzUpMw+wPQocPR2Ru0ang4HlyOLiaj8zMT+dS9ueHKQShQ0OlcMSJ0Gj07FKKVE+uuwDHRoUUG1alfND3KYmZAiB96bBlAmQV3iW+MeDI5Oi01p4EjA8rNJP1GvFvqfYKGwB0vd7qMcRDXQSgGSSGJirzYcCFqJpKNgD56ZQbOs3SRpULvf4cp/kEWx6DIS/3fvr86c+d0T0zcZ6o1twbTznerKz8xm/AwQs9NSQCTZAtguwv3DpNkpc1g8D1ovYbN4A9wEP6RYb4Lb3/jx2Cq/TBJmeCrK1VrqQuOkH2goalTS1aslgpphXlUqK7H/bDD+SKI7iglbJVqarl4G/VAdMIMGiXP2AKQi8gHjJ8TT3ABoXn/xh1/dj0g5p1OArB4C6bDQLeYdD7KuFoRdbybUEaVMne91FJ94Ca+h5QfhrcEKRZsMWGGAak9c9nCgB4fhUkW40wxzhYh+S9Cejvd7df/gQzCBydsMTFs3MDLApfZ/lNA7Da4IyA88UeKtD3tYYV9rHAbK9zBCnexwpdY4Sus8DVW+AMK/BZaiuLUw5A6AreQvKduzHfR5kLsh2EGhD7IZh8pUv0zWFJuz9OIXFvanPbI/uzvOq+e9tHSbbR0By3dRUtfoqWv0NLXaOkPaGlvCy/Gseuh6J2BP6pYPDBVhXrfnzHxHGRJGs0r9Q6lQrEbRoowMRPOF1ebwl5S17sl/g25UjTWFMZzJqBmophZ8yS32g4BixwSrmZAXsv6cVlPg4Ty4dic0z3WMu8kSkQD8fczBwZxnl3hiniKY9rDUVWIAagOBpKzwnG8khR5ObXFVFjm7i+fmwmS8z80jsppKzU6/f5KVpvwk5nzsk6VLChQRAl+m7IjwQkbQvB2YTAt4kEDIC0ra+m4FAAyaKfkLz+RrWq0xn6QOi04Qhx3iUtXC3ro8zKPpCISpo78r2xwCnusF2Q/SfyP4ZxbyHBGZqDQiy7s78IBhQ3wEKs6hD5oxYXr2+ZXLahca5HU7eWiynmolZvsNgt8fAYSJ2zr6ye3DD2JpyV+ei7zGr4C/aUroMLK6L8MEhTp/SyN8sXM17IHM4u60sdl/6UlQEews/7ZDTLa0mGGjf6Q3rhZkIqxmIZiCkp4zc60LYbzw2pYjFvTTl6cF5zfsOFZ8b3wolhljk9MvSie5T9Y7OihDbMUMyDYySGdwocABnLRYM5RFMxo3GVBnNWDNyyE8osyRbl9UaSxh2qB3NMX/NO6EsoehN/pb/V2ey9F+AdMzYyodS97r6x1r3qv87BRCcmYRQpzMSbXd6BcA3/uA3ASUKxJKQAa6CABuefMm0GVaD8BT/fgrhyt5XShyd8yMJPj9I4tbfK5LXzGOe2Ww3T7zgMaE1ouD3ZEmGyU01QK4wFfjV2LTtY5HXiFME80YYJxAozXPXW/Gu2uxMTTNjB9rgryEsZuvLuxp+XhWFOjC2gsGn2XqfR8YymRcLnrgU8Ky/GGss0Kj8tw3s05UQtvlpvZ9upbc9UVwMA/LEImOjDlmKIF/9tAqRaZ+4JtnaEocFhUlP3LAqHs32Mf4Asdbj20/t2ir15ejKWXF2Pr5cVcenkxN7qQFs/KSiwmW9FtESoVy4hGb68wdKSVXdV16Tml+sIRZEJw44KjaXKPwo+GhqzxaypUET6qKhtxkAaERkhwKmjsR3wB1eCDFLJgv/bziBg5D9Xfky+R1lmLcNhjH+UgPflHnzNyKDbH1d6uKtr30ozv3auiwltlhe8nQ6kX+1V1YL/ktuoG8mFDD5Ue6x1tIJzKzFdJWNXfNTHT3V4TUWsLCRe9jUIGrNI6ukYkvVoPQpjRq/qYXslTapXGYJZKwW3WIGJtsLFhTFJmSrzGdjbeYDurRw0OfKLSS2h6GLfLN1MtZWfdeSkr3RAMGmqyWQVusvucM41JlTVDFlEh8XPy5oQf0jnmkso0hnZB3g4nkWW3piOmqyKDQk/xWaednfaa6QHmPq2GcW38bvFVtxv4qpIRfmqhvdgfbPH//vm/RNodyMDv4CTWAAIK6yF1PruTRgvwmT/TwEFH310estkR3CPOHqKY3MAmWoqNqXEjKVg1feb0nGqbfUpjRpu/ZaBTqcTrZ+CL09lfI1+fd9fRlwbWCk2REiPpzcXBw4PG+tVJGJuSOYLdE3qTwlaZxhWwpT2wJGTZfRgNTevsSpJJ07ySJmkb6PmPmpyh57j8q6e3ROV2LGJVuxiSlC2Fjvm9UjPOzD4wjhy6MGD68cmTK9nYsMDKKGSnkeClsshvnJI5t+TRDRSBgbspgxR31I2ftoKb9mH3DUDV77/obxNosdV7sbXzor/VBxMzlVJd+GCsE4fNi8IkCvwZP3dZCFeEYcAKWtB5u0N2OqTXJnOauuRqlFy4MYg+AM+4746nenS4Mtpz8rid3uaS/iPzYXKRFiLHaEwqrX36uvt4p6+CLwianyWxld6Mr7sy4f3Ww5XWaiozgT6CLXwFqxrSLzyTJclPtFE6aUEvI5DcKPhQ0KHGzX+QY9QNvQtLLOK+3ofwcu1a4z6IJg8r2gDTeTCShoQlMDPDJEOwJM3oQYV0RauA56StYhTQuWvzk3T/N+/WretihNgjMN35YbEAbklMAwXTKY+RysOxleDih2cHbvipOC6rPShbfWiRtbR0cJbAJ0vLInA9QJmH2GVh4eVF4N1Kxw7PB3ScTt4hVnoymRVEW+mAUgOq9MMw34uzueKAFSVihukap1d6qHA19qs4xXLetdZxV0kBVPNryqNn13pahtK9qdw0hTdAFF7ZUCqq2pWgOp74S4VU4DbMwLvyWEi6gnUIjosfeqmpDXtcTRTDKX4LMqBstYrcGG6qbEYqz7N6LpLruD3jK/mt5srMmXpMQ2XLyioW4EEnlDqfTCXoGEdBwA+RHuFo6iJww5DJxPfQMaaey9b14y/FLEJmEmmXtOK5UHFa9fiHQZi87iwV2HVOg1C/u99gi73T8Dhop9lx0Fo8boCNHqjYE7l/pTOhlTU9ktst42F4QH/ekyGUXW0RoZrDocYnNLV82fSIhoXAcOI0WN3usPESm0c3lhWR72tJV7SkW1nSRSzp7pV03Uq6YSVdqpLuUclXp+TbUvIFqeJvacbeTmG+f8MAVqumi67EEsY1kfoV/rUvjPS4FVgr9RfLXf6GC15lHrBRMwq9mNtukRvsGNmXVQM9Fyr157RJ8m9twhaDbH8eZUbqkOZ45sgbab5KAxz5Iz8B1AlyuLVKBoN+DMIS28Dz+uf/ga8jUENSsLSUvgrZ6So5OkY6o5jpqQFDkbaXD51nPGrn6LwUy7AxmZGRT6Twldck+NTc8Rhn85aKUbF+QcDvfsgHcOD8xeJaJB/gQ7FGvKGaa7pXDsBWsEM0oPZANDpEZ3u9EyoWeqNSKvQKTSj2NJTkBkwoqvpCLBgAFRuY/SuuMOuK7EKjpqK12UkThKUNUHoogqIiNbWdDVkYVmG90vhXnJRzqpk6UXJKrfnV0jGIzGCmxkWULKZYrbpUUZ+IxjR1pK4SVR0oJ5CqChDReDYdp6k19JaJjni394dEffUDZpPdePqDAk+ebPCAp1g0yV3W4rr39Rd91s1I1E5h7zGzuezo35LrpScjiut6RIRjAL20PHe90hlIjczlJRr6uJu1vRRjLfnrHvNiHiHZYTvn0aS6QLXIRxc4l7IxfeZsOc+uNCim0lU/dWpbBIa0+m00CqMFaopxRb11tOqsRjmq2QR4NgGeTYBnE+DZBHg2AZ7fDoCbAM8mwPPoAZ6a23p/1NjPSrknSAwIOwL+A2YhWpPmHpq1KqDOdyH/tky+tS7W5kA32JGud2l05S3pCje7/2V70vroqX4BCaMkAtpvMqK6JHb6Z4itkrWCqwKjbwytMvWqK/O9YuoGusEAR2e6PVY+te5MNxHctcKYf7Ko7e8rUovu3owQjJxppcdqMY4zFgpbE4w4phmQd8FRPOOSgNCCVy1JCMtDNI0gaWaj1kkvNNHgZh+xzVhy4GrxXzNH8L7MEbTmSTbKPtTDv+ulHhap79+TIi7qRfNrP6QzPA+xeIWCt2ndL4vidpbn5K+Wg14EXStsO0YCpZTfyZx7vbKRW2+kZK7i0NeBc6/Wdoua1SyeBc7Cm8SmYH65nle97ks5XpU9uwSZdVSGpNlW1hUWG6xA1CibHFESy9LIV4FCZZqeZc9rJJmbu5Pf9XWLnmOb/Ne/b1ETQ/mV71jsWW5YJN96w2LPer9CG1p7MW3duyjGy2X8r25vfdL8Nq6fIBttqz7r1Sg0+42UxpqtIm6TfcbaMqGp3p7dFiAEwFTfN0Cy4o0DxbOykeuhziT1a22S4W2va5Mk6aizDCvewjFwWR7mlwCpdUAx8tQ/JVxrdpu759r01cJaiFd7h0R9st5yi2btC7Sb54ttJ0Sb54s3zxfzBpvniwXwm+eLN88Xo88Xs0a/4/eGZdurTl8Z3iI1MakxtOt+IMaS55fbbSExC9DITGqYH4p9JUYABFBavpbFbTH6PRhbJog1EaScpC7jYy1nEP0IzJvYRYykPQcjP7gREQfzuyllxw/mA17C5EWheH0lH92awdHiD9oE+QdF2GFNu6a5WcUNHRkzst0h2rI0Xb7ddF3QkB1XJUh3YbQ83GgdA2+AobqUclCMrjz9NmHUsFDiDMjG+XIhpwFL4wz9mxtw7ZnKvqbpFwqKoa65GK9YgsRYXLuD39y/V85qDE7BGWDpkkuL/Aj7wPLMpeLSCi4BO0aKhgmnyHawEDB9lg5RWRQPy6vzojuVM/olf8Wo5hGbzV5ls1fZ7FU2e5XNXmWzV9l8amXzqZXNp1aQj5k0P+XQs0JzW8y9WGDjNOP+boMvuKgfbZG/09LACmuWV7W1K1xeLexsYVg1S4qbTtNYqtax1hyaBsBQ+biSr9R6pcor9V2p7EpNV6q5UseVCq7UrqRqJfUqqdRcjUr88jZc+J/5jtrg8LyKu+91Z1KIg6s8gIW4xw08YqsTjD/xutbr8YU5QB60bJ53UcPmiJeKmh5ZSbNchf00jf3rTMiQyIuwX+FkDAkiAlssrkr4MSx+mxNbbW027IJnOUE1fqvltcneTySMUpErzQTVhUVq3TtbTrfr/MDw8Pjtz+I3/1HOJY65qp/9mqPamtO5RsToqPOunUePntrJKOifLV3zC1PiWpZ6w0SaZvoX/p5szlt5LqfF/jW5xbLtlPnE+VuN0IfHDHEMmjwJ3qtQqHIlFCR+4teoAfZ4CQq2q7r6I+EKCuLqbQ0SlpfH9du2JRKll8BcOhmPPWMpctewEH4e18j9QWfBERZFVn7fsfO79kK5zn4OkqgiX+VThF8K37Jyk8EZVbl0Kw9Cak0KgvfZ/QiZWk6R0FVcplgvY06D2fKe48bYrGVsOjqbdlQWteiwl7YL5kY+ITgfwC7cY/TDcg41g5OXTp9fSRNbjgdWe4viJdfP2PwW33nlryyUmvPKmCXfR1hfdt9WAqG6Blkj/JlXfMiHeLwwqAqazcSpzXqWN8/VVsqT5/oAyjMasplYhzh8gEcnjQKWjTA67AhV5CYKTZS+P3735DuJY6w3QNdiHhjtgxjtQ5EF+oiB9Ee5U42+ui9XLPl8hNppFC5gR8gY7gXMOZ+DKUjv2Cc02W4HgTBekKEfgxqABXlBRuMh/P/02Gh4eszGOz89fXs2mrxn402ODy+NZu/2L4djPcTV4PMWGlS2+H8Vlpc/fGFWpqkwCSayUQybXnLCvtxCdgCgEneaqiujHvko/KEyrDV/ex1+rQZ7fHY1csnjaM6/mFNkk2NnHzXJ53rzpGo+qzltOTseF0Oor5rrfFzzADoyIpcvYfrMk2/eAohkbQBe3NyNfRavGZ8PRvwUnk35nIwuTC7n0ZsoIMIFYczz1QuyGZ2ZYpNzBLtJfeAGPGSS8CwFVoKNnXtTTYkBEHLtILKjARCR/W4iGM1hZhzLhLTesjIGEpuAj3/hep+SdsPVAyjeTQ7J+dnJ++WrU9e4gJ8Xm7TZH4AOGo7O3qBVw8Px4HJ0MRmdn5n45/Fr0JpcA4FOrHxFjdjPDoVA5fS6K7BE2MYc1boCR1nMz4thv8HWws2/mKYry5PJ0al0YUEdYz9JKIsK4BIzGPOAPQvrWUc4cEOjc52q+39QSwECLQAUAAIACACSvsxWBIIOoqcAAAD3AAAAEgAAAAAAAAAAAAA.
A connection could not be made to the data source with the DataSourceID of 'e5dc5e63-ab2e-4a87-9615-da4a01f01023', Name of '<ccon>Query - Subjective Mapping Table</ccon>'.
An error occurred while processing table '<ccon>Subjective Mapping Table</ccon>'. (<ccon>Subjective Mapping Table</ccon>).
The current operation was cancelled because another operation in the transaction failed.

5 Replies

  • SandwichNo1 

    As variant, creating PivotTable or loading the query on desktop you added data to data model. Excel for web doesn't work with it. Please check on desktop your Power Pivot window is empty.

    • SandwichNo1's avatar
      SandwichNo1
      Copper Contributor

      SergeiBaklan 

       

      thanks for getting back to me. So have I got to rebuild the pivot table in excel web instead in order for it to then refresh? Thanks

Resources