The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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,
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.
Regards,