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: 

A new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.

msupawadee

missing Data View Option when getting data from SQL database

Submitted by on ‎03-30-2017 09:21 PM

Hi All;

 

Normally; in the left hand side; we have 3 options for Report View, Data View and Relationship View.

when I get data from SQL database; I did not have Data View option.

 

Anyway; I tried to get data from Excel; there is no issue; Data View was there.

Can someone help?

 

Thank you

Regards; Supawadee

Status: Needs Info
See more ideas labeled with:
4 Comments (4 New)
Comments
v-haibl-msft
Microsoft Employee
Microsoft Employee
‎04-03-2017 12:22 AM

@msupawadee

 

What is your OS version? Are you using the Mar 2017 version of Power BI Desktop? I cannot repro the same issue as you on my side. My OS is Win10 x64. Could you please post a screenshot for your PBI Desktop?

 

Best Regards,
Herbert

 

Vicky_Song
Impactful Individual
Impactful Individual
‎04-03-2017 12:23 AM
Status changed to: Needs Info
 
Douga
Frequent Visitor
‎08-28-2017 11:47 AM

I'm having the same issue when connected to SQL Server. OS is WIndows 10 x64. I'm running the most recent Power BI Desktop version as of 8/25.

 

Here's a screen shot.

Missing data view iconMissing data view icon

dr3sss
Frequent Visitor
‎10-25-2017 12:50 PM

I'm having the same problem but when I connect to a regultar transaction DB. I mean, like a regultar sales DDB. But when i connect to a SQL Server data base with a star model, dimensions and facts, i can see the data view...

Idea Statuses