Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Error Retrieving Power BI Service sources: sequence contains more than one matching element

After updating to the November 2017 build this morning, I am no longer able to select Power BI Service data sources in Power BI Desktop.  The error in the screenshot below pops up immediately every time.  I tried uninstalling and re-installing, rebooting, etc.  I haven't found a way to clear the error.   I'm dead in the water until I can get this fixed.

 

Need Help

10 Replies

  • hoffmanrat's avatar
    hoffmanrat
    Frequent Visitor
    8 years ago

    I know that this says solved, and that there was an apparent fix applied in December, but I'm receiving this error now with Version: 2.55.5010.621 64-bit (February 2018). Anyone else?

     

    I receive this error when trying to add a new datasource in DirectQuery mode.

     

    It's a strange error exception message to receive as it doesnt suggest what is actually wrong and there is both no technical detail provided in the error message and nothing online. All I can assume is that there is something broken with the service.

    • zacuke's avatar
      zacuke
      New Member
      8 years ago

      I'm having this exact issue too. Has any body made any progress? I can't add any new queries to my report, which is a blocking issue.

       

      I've sent in a frown bug report.

       

      Edit: Well, as is the way of life, after posting and sending in the bug report I thought of something. I deleted all the existing queries and I was able to re-add everything including my new ones and so far so good. 

       

      So, as a work around, delete existing queries and re-add everything. Fun.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    I ran a Fiddler to capture the JSON from the app when it calls out to the service to get the available sources, and there is an ID that is duplicated for my personal workspace.  I'm sure that's it.  Does that mean there's a bug in the service?

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Anonymous,

      Do you use the latest version of Power BI Desktop(2.52.4921.682)? I can successfully connect to Power BI Service dataset in this version of Power BI Desktop.

      In your scenario, I would recommend you click “Send a Frown” to report this issue, it seems that there are some issues with your workspace.

      Regards,
      Lydia

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Yes, I have the latest build 2.52.4921.682 64-bit (November 2017)

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      I have the same issue.

       

      I know that when my organsiation signed up to Azure/Power BI; I origianlly had problems with there being apparantly 2 accounts for me (I used the same email address for my trial before we signed up to MS).  I wonder if this is causing the problem?

       

      I have a service account; I did manage to connect to the BI Service with no issue from PBI desktop when using this account, further supporting my theory.

       

      Anbody solved this?

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    I still have this issues in my Power BI Report.

     

    I have report this issue multiple times, and there's no response from MS Team which is frustrating.