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.

rymy_2378

Major glitch - "Get Data"/ODBC querying function

Submitted by on ‎01-30-2017 08:59 AM

Hello BI team,

I have encountered a major glitch that needs attention. When trying to input a multi-line SQL query under the "advanced options" section of ODBC (under "Get Data" >>> "Other" section), the open window will not allow the user to scroll back up in order to minimize the "advanced options" so that the "OK" button can be pressed and the ODBC query submitted for data processing and pulling. This virtually makes pulling ODBC data via SQL query currently unusable. If you could address this as soon as you get a chance that would be great...thanks! See screensot attached for a visual of the problem.

 

Capture1.JPG

Status: Needs Info
See more ideas labeled with:
3 Comments (3 New)
Comments
v-haibl-msft
Microsoft Employee
Microsoft Employee
‎02-01-2017 06:53 PM

@rymy_2378

 

What is your Windows OS and Power BI Desktop version here? I just tried on Win10 Ver 1607 (OS Build 14393.693) + PBI Desktop Ver 2.42.4611.901 64-bit (Jan 2017), the OK button in open window can always be clicked without scrolling. Its position will not change even after you input a multi-line SQL query.

 

Major glitch - Get Data ODBC querying function_1.jpg 

 

Best Regards,

Herbert

Vicky_Song
Impactful Individual
Impactful Individual
‎02-01-2017 06:55 PM
Status changed to: Needs Info
 
rymy_2378
New Member
‎02-15-2017 09:30 AM

Hi Herbert,

I am using Power BI version# 2.43.4647.541 64-bit (February 2017) and Windows OS Version# 6.1.7601 Service Pack 1 Build 7601.

 

Idea Statuses