cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
pgerasenkov
New Member

Empty table by SQL Server connection

Dear colleagues,

 

We use Power BI Desktop and don`t have troubles getting data from our database via xls-file (around 10 sheets) and than upload data to Power BI.

But when we try to get data directry via SQL Server using the same sets from xls-file (ip-adress, port, password), we see only one empty table. What is a problem? 

 

Thank you,

1 REPLY 1
Microsoft
Microsoft

Re: Empty table by SQL Server connection

@pgerasenkov

 

What do you mean "get data directory via SQL Server"?

 

If you directly connect SQL Server in Power BI Desktop, you should be able to see the all tables under databases with schema info in Navigation step.

 

55.PNG

 

Regards,

 

 

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.

Top Solution Authors
Top Kudoed Authors