Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Cannot load new table added to azure SQL database : sequence contain more than one element

Submitted by Anonymous on ‎02-07-2018 03:00 AM

I just updated to the Feb 18 version.I am using direct query to connect to a Azure sql database to which I have added a new table. I loaded the table,but when I click "close and apply" in the query editor, I get an error "sequence contain more than one element".

Status: Needs Info
See more ideas labeled with:
9 Comments (9 New)
Comments
v-qiuyu-msft
Community Support
Community Support
‎02-07-2018 10:37 PM

Hi @Anonymous,

 

Do you use 32 bit desktop or 64 bit desktop? Based on my test in Power BI desktop version 2.55.5010.521 64-bit (February 2018), we can apply change when we connect to Azure SQL in DirectQuery mode. 

 

In your scenario, please try to connect to other table to see if issue happens to all tables or not. 

 

Best Regards,
Qiuyun Yu 

Vicky_Song
Impactful Individual
Impactful Individual
‎02-07-2018 10:40 PM
Status changed to: Needs Info
 
EssiSH
New Member
‎02-08-2018 12:08 AM

Hi!

I have the exactly same error. It is not happening to all tables/views, but to some of them. Error happens even if I remove all modifications done in edit query.
After I change to import mode I can use the view. But in this case direct query usage is needed.
 
I'm using 64bit version of PBI (Version: 2.55.5010.521 64-bit ).

Anonymous
Not applicable
‎02-08-2018 12:12 AM

@v-qiuyu-msft @Vicky_Song

Hi All,

I'm using Version: 2.55.5010.521 64-bit (February, 2018)

v-qiuyu-msft
Community Support
Community Support
‎02-08-2018 01:36 AM

@Anonymous Have you tested with another tables? 

 

@EssiSH As the issue only happen to specific tables or views? Would you please check if any difference between those tables/views? Could you share T-SQL query to create issued tables so we can test it on our side? 

 

Best Regards,
Qiuyun Yu 

mhaldima
Regular Visitor
‎02-10-2018 06:56 AM

Same issue here. Many but not all tables suffer from this issue. A simple example is the following:

 

CREATE TABLE [dbo].[Shares](
[Email] [nvarchar](50) NOT NULL,
[a] [int] NULL,
[b] [int] NULL,
CONSTRAINT [PK_Shares] PRIMARY KEY CLUSTERED
(
[Email] ASC
)WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

Anonymous
Not applicable
‎02-13-2018 03:15 PM

This is also occuring with Direct Query and on premises SQL Server data sources.

Anonymous
Not applicable
‎02-13-2018 09:39 PM

@v-qiuyu-msft There were already tables present in that Azure SQL database which were loading without any problem. It was the new table causing the problem. Anyways,I sent the .pbix file to another machine which had a previous version of Power BI desktop and loaded the new table without any problem,sent it back to my machine, and then it worked fine.

mhaldima
Regular Visitor
‎02-14-2018 02:00 AM

Some further testing shows that the problem occurs in fact with any table that one tries to add to a Power BI file that already contains SQL tables connected through Direct Query. The workaround is to remove all existing connections and then to add all tables at once, including the additional one. This works, but is obviously not very convenient ;-).

Idea Statuses