Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Duplicate Data Source error for brand new, virgin report

Hi everyone,    We have a PBI implementation in our company with Enterprise Gateway installed on-prem installed on our servers and we have been actively ustilisng on-prem data in the PBI Cloud, by ...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Apparently this is a bug as per this post. Closing this post for now.

     

    Thanks

    Kaz

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Anonymous,


Do you mean that you move PBIX file to new folder? Could you please search more details in gateway log when getting the above error? 

Thanks,
Lydia Zhang

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Anonymous

 

I moved the SSRS report to a different folder, not the PBIX. Below is the exerpt from gateway log. Green text is the bit where I have trimmed the corporate SSRS portal, in reality it is a well formed URL.

 

DM.EnterpriseGateway Information: 0 : 2016-11-22T05:01:50.2217266Z DM.EnterpriseGateway 44723129-685c-4e2a-a4e9-ce4ba6f7c824 beda5602-42b8-c97c-28e4-5be54b86def5 MGPP ea368963-6d02-b042-8257-feaeff22c33a 7683252B [DM.GatewayCore] Deserialized EncryptCredentialsWithTestConnectionRequest, executing
DM.EnterpriseGateway Warning: 0 : 2016-11-22T05:01:50.2373268Z DM.EnterpriseGateway 7416b71c-ce94-4940-93c2-2e67246d9f73 beda5602-42b8-c97c-28e4-5be54b86def5 MGTD ea368963-6d02-b042-8257-feaeff22c33a 23617C10 [DataMovement.PipeLine.MashupCommon] Connection string <pi>DSR="eyJwcm90b2NvbCI6Imh0dHAiLCJhdXRoZW50aWNhdGlvbiI6bnVsbCwiYWRkcmVzcyI6eyJ1cmwiOiJodHRwOi8vcmVwb3J0aW5nc2VydmljZXMud2VzY2VmLmNvbS5hdS9SZXBvcnRTZXJ2ZXIvUmVwb3J0Lz8vUmVwb3J0IEJ1aWxkZXIgUmVwb3J0cy9JbmZvcm1hdGlvbiBUZWNobm9sb2d5L1Bvd2VyIEJJIERhdGEgU291cmNlcy9TZXJ2aWNlIERlc2svSmlyYSBUaWNrZXRzIERhdGEmcnM6Q29tbWFuZD1SZW5kZXImcnM6Rm9ybWF0PUNTViJ9LCJxdWVyeSI6bnVsbH0="</pi> is not a valid M connection string

DM.EnterpriseGateway Information: 0 : 2016-11-22T05:02:01.5630720Z DM.EnterpriseGateway 45d92b24-430c-470d-9331-2856993b695d d1d42946-7b9d-ef19-427c-1c4a40c29273 MGPP ea368963-6d02-b042-8257-feaeff22c33a 7683252B [DM.GatewayCore] Deserialized EncryptCredentialsWithTestConnectionRequest, executing
DM.EnterpriseGateway Warning: 0 : 2016-11-22T05:02:01.5630720Z DM.EnterpriseGateway 82ddfd18-4f2b-45a4-8ddc-d9709251da35 d1d42946-7b9d-ef19-427c-1c4a40c29273 MGTD ea368963-6d02-b042-8257-feaeff22c33a 23617C10 [DataMovement.PipeLine.MashupCommon] Connection string <pi>DSR="eyJwcm90b2NvbCI6Imh0dHAiLCJhdXRoZW50aWNhdGlvbiI6bnVsbCwiYWRkcmVzcyI6eyJ1cmwiOiJodHRwOi8vcmVwb3J0aW5nc2VydmljZXMud2VzY2VmLmNvbS5hdS9SZXBvcnRTZXJ2ZXIvUmVwb3J0Lz8vUmVwb3J0IEJ1aWxkZXIgUmVwb3J0cy9JbmZvcm1hdGlvbiBUZWNobm9sb2d5L1Bvd2VyIEJJIERhdGEgU291cmNlcy9TZXJ2aWNlIERlc2svSmlyYSBUaWNrZXRzIERhdGEmcnM6Q29tbWFuZD1SZW5kZXImcnM6Rm9ybWF0PUNTViJ9LCJxdWVyeSI6bnVsbH0="</pi> is not a valid M connection string


DM.EnterpriseGateway Error: 0 : 2016-11-22T05:02:01.8282754Z DM.EnterpriseGateway 82ddfd18-4f2b-45a4-8ddc-d9709251da35 d1d42946-7b9d-ef19-427c-1c4a40c29273 MGTD ea368963-6d02-b042-8257-feaeff22c33a 139A19EC [DM.Pipeline.Diagnostics] Exception object created [IsBenign=False]: Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.MashupDataAccessValueException: Mashup expression evaluation error. Reason: .; ErrorShortName: MashupDataAccessValueException[HResult=-2147467259,ErrorCode=-2147467259]/Wrapped(MashupValueException)[HResult=-2147467259,ErrorCode=-2147467259]
DM.EnterpriseGateway Error: 0 : 2016-11-22T05:02:01.8282754Z DM.EnterpriseGateway 82ddfd18-4f2b-45a4-8ddc-d9709251da35 d1d42946-7b9d-ef19-427c-1c4a40c29273 MGTD ea368963-6d02-b042-8257-feaeff22c33a BB38BE25 [DM.Pipeline.Diagnostics] Exception data: DM_ErrorDetailNameCode_UnderlyingErrorMessage = <pi><pi>Web.Contents failed to get contents from 'http://reportingservices/ReportServer/Report/?/Report%20Builder%20Reports/Information%20Technology/Power%20BI%20Data%20Sources/Service%20Desk/Jira%20Tickets%20Data&rs:Command=Render&rs:Format=CSV' (500): Reporting Services Error</pi></pi>


DM.EnterpriseGateway Error: 0 : 2016-11-22T05:02:01.8282754Z DM.EnterpriseGateway 82ddfd18-4f2b-45a4-8ddc-d9709251da35 d1d42946-7b9d-ef19-427c-1c4a40c29273 MGTD ea368963-6d02-b042-8257-feaeff22c33a 6A5E25DC [DM.Pipeline.Diagnostics] Exception data: DM_ErrorDetailNameCode_UnderlyingHResult = <pi>-2147467259</pi>
DM.EnterpriseGateway Error: 0 : 2016-11-22T05:02:01.8282754Z DM.EnterpriseGateway 82ddfd18-4f2b-45a4-8ddc-d9709251da35 d1d42946-7b9d-ef19-427c-1c4a40c29273 MGTD ea368963-6d02-b042-8257-feaeff22c33a 8AA61592 [DM.Pipeline.Diagnostics] Exception data: DM_ErrorDetailNameCode_UnderlyingErrorCode = <pi>-2147467259</pi>
DM.EnterpriseGateway Error: 0 : 2016-11-22T05:02:01.8282754Z DM.EnterpriseGateway 82ddfd18-4f2b-45a4-8ddc-d9709251da35 d1d42946-7b9d-ef19-427c-1c4a40c29273 MGTD ea368963-6d02-b042-8257-feaeff22c33a 7BA84428 [DM.Pipeline.Diagnostics] Exception data: Microsoft.Data.Mashup.ValueError.Reason = <pi>DataSource.Error</pi>
DM.EnterpriseGateway Error: 0 : 2016-11-22T05:02:01.8282754Z DM.EnterpriseGateway 82ddfd18-4f2b-45a4-8ddc-d9709251da35 d1d42946-7b9d-ef19-427c-1c4a40c29273 MGTD ea368963-6d02-b042-8257-feaeff22c33a AF2014BE [DM.Pipeline.Diagnostics] Exception data: Microsoft.Data.Mashup.ValueError.DataSourceKind = <pi>Web</pi>
DM.EnterpriseGateway Error: 0 : 2016-11-22T05:02:01.8282754Z DM.EnterpriseGateway 82ddfd18-4f2b-45a4-8ddc-d9709251da35 d1d42946-7b9d-ef19-427c-1c4a40c29273 MGTD ea368963-6d02-b042-8257-feaeff22c33a 43461E06 [DM.Pipeline.Diagnostics] Exception data: Microsoft.Data.Mashup.ValueError.DataSourcePath = <pi>http://reportingservices/ReportServer/Report</pi>

 

 

Thanks

 

Kaz

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi Anonymous,

    I am not sure how you create the data source under gateway?Would you please post a screenshot? It seems that you combine gateway and SSRS report, also as indicated by the above error message, gateway is unable to get data from Reporting Services.

    Thanks,

    Lydia Zhang

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Hi Anonymous

       

      I am creating the data source by using the following options/steps, and I am not doing anything different than what I have been doing to establish other data sources. In fact, I established the same data source, after moving SSRS to a different folder, and it worked. This is confusing.

       

      Step 1Step 2

       

      Thanks
      Kaz

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        Hi Anonymous,

        I make a test when adding data source using the following URL , I get same error message as yours. However, if I remove the "&rs:Command=Render&rs:Format=CSV" part from the URL, I can succssfully add the data source.

        http://reportingservices/ReportServer/Report/?/Report%20Builder%20Reports/Information%20Technology/Power%20BI%20Data%20Sources/Service%20Desk/Jira%20Tickets%20Data&rs:Command=Render&rs:Format=CSV

        Please directly enter the following URL when adding data source. You can test it when moving your SSRS report to your original folder and deleting the existing data source.

        http://reportingservices/ReportServer/Report/?/Report%20Builder%20Reports/Information%20Technology/Power%20BI%20Data%20Sources/Service%20Desk/Jira%20Tickets%20Data


        Thanks,
        Lydia Zhang