0 Kudos

Cannot Load Power BI Service Data Sources: Sequence Contains more than one matchin element

Status: Accepted
by peytonmcbrayer Regular Visitor on ‎11-21-2017 06:32 AM

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.  I used a sniffer to get the json coming back from the service, and there are two instances of the same workspace/group in the file.  It looks like the service is returning bad data.  HELP!!!



Status: Accepted
by Moderator v-qiuyu-msft
on ‎11-21-2017 11:15 PM

Hi @peytonmcbrayer,


I have reported this issue internally: CRI 52375764. Will update here once I get any information. 


Best Regards,
Qiuyun yu

by Vicky_Song Established Member
on ‎11-21-2017 11:16 PM
Status changed to: Accepted
by Moderator v-qiuyu-msft
on ‎11-27-2017 05:22 PM

Hi @peytonmcbrayer,


The fix will start being deployed to PROD on 12/4 (all PROD by 12/9 at the latest).


Best Regards,
Qiuyun Yu

by JohnOCallaghan Regular Visitor
on ‎11-28-2017 05:23 AM

I have the same issue, but also cannot use the "Publish" button (PBI does nothing, no error, nothing).


Whilst trying to reolve my issue outlined in this thread, I realsied that I could connect to the PBI Service via PBI dektop using one of my "service accounts".  So this supports the theory of some form of duplication (I think it is accounts rather than workspaces).


So I have also tried to "Publish" a report from PBI desktop using the same service account; works no problem.


This suggests to me that the issue relating to the failure to connect to the PBI Service via PBI desktop also relates to the issue I am expereincing re publishing from PBI desktop.


Any ideas?

by peytonmcbrayer Regular Visitor
on ‎01-12-2018 11:49 AM

 @Vicky_Song  This is resolved.  Thanks. 

Idea Statuses