Forum Discussion
SandwichNo1
Jun 12, 2023Copper Contributor
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?
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
Sort By
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.
- SandwichNo1Copper Contributor
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
You need to use cached PivotTable, not one which is based on data model.