Forum Discussion

nsmithsd's avatar
nsmithsd
Frequent Visitor
7 years ago

PBI Report Builder V2Workspace XMLA Error

I'm getting this error when trying to connecte to datasets in a V2Workspace:

 

COM error: Microsoft.MWC.Workload.Client.Library; Microsoft.MWC.Workload.Client.Library.Utils.WebApi.PBIServiceException.

 

Datasets in V1Workspace worked ok.

4 Replies

  • bradsy's avatar
    bradsy
    Microsoft Employee

    Hi nsmithsd,

     

    I cannot reproduce the issue. In PBIRB, I tried to connnect to data sources in both V2 and V1 workspaces and did not hit any issues. Is this happening when trying to get the connection string? What are your repro steps?

    • nsmithsd's avatar
      nsmithsd
      Frequent Visitor

      bradsy - I copy and paste the server settings connection string from the service into datasource in PBIRB using the anaylsis services option. Then get that error when trying to use that datasource in a dataset. Curious what your security trim level is in the V2 workspace, I'm an admin.

       

      Anonymous what security trim level are you using in the V2 workspace?

       

      Thanks!

      • bradsy's avatar
        bradsy
        Microsoft Employee

        Hard to keep discussing through forum. You can reach me directly at bradsy@removetextmicrosoft.com.

         

        I assume your capacities are all premium.

        1. Run Fiddler. This can capture the web traffic from RB to the service, may give us more information. If you can send me the trace minus any private information, that can help.

        2. If you can let me test from my Report Builder by using a test account or such, that can help as well.

         

        The step that is failing is Add Dataset, then launching the query designer?

  • Anonymous's avatar
    Anonymous
    Not applicable

    I am getting the same error.  I have two workspaces, one V1 and one V2 and when i publish the same dataset to both, i can connect to V1 but not V2.  I tried creating new V2 workspaces but same result.  I'll post back if i get it to work.