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,

Agree with smoupre.

I can reproduce your issue when creating another data source under gateway if a same data source already exists, you can check the following screenshots to get details.



In your scenario, assume that you connect to the newly created dataset via import mode, don’t create the data source under gateway, directly check if the newly created report renders properly in Power BI Service and if you can set schedule refresh for the newly created dataset.


Thanks,
Lydia Zhang

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi Anonymous & Greg_Deckler

     

    I verified that this was a brand new report, with no chance of duplication as all existing data sources were from business areas (finance, HR, inventory etc.) where as this report was more of an IT dashboard with IT Service Desk KPIs data. 

     

    I managed to work around it by moving my report to a different folder all together, and it worked as expected. Leads me to think that the original folder was causing some sort of permission issue that was leading the PBI Cloud service to think that it was a duplicate data sourece? 


    Your thoughts? 

     

    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