Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
When I connect to the database via SQL server, I don't see all the tables I have on that DB. It seems that it gets to the maximum of available tables and there is no way to find in this preview the 100% of the tables, not even filtering them by their specific name they appear.
Is there any way to visualize all the tables to be able to select them and import them to the query editor? or is there a maximum of available tables power bi does not allow me to see all the tables?
Thank you
Solved! Go to Solution.
Hi. I think I have never seen something like this haha. Please check if your ram is not at the top. Another solution that is not very easy but can help you right now is writing a query before getting that screen. When you complete your instance and DB name go to advanced options and write your query "SELECT * FROM Table" to avoid that screen and continue your work.
I'll try to check if there is some kind of limitation on that screen.
Regards,
Happy to help!
Hi @Anonymous ,
If you plan to import several tables, you could use power query directly.
Here is the format. You could also import any table at first, then open advanced editor and copy the codes for reference.
let
Source = Sql.Database("server", "database"),
table name = Source{[Schema="",Item="table name"]}[Data]
in
table name
Hi. I think I have never seen something like this haha. Please check if your ram is not at the top. Another solution that is not very easy but can help you right now is writing a query before getting that screen. When you complete your instance and DB name go to advanced options and write your query "SELECT * FROM Table" to avoid that screen and continue your work.
I'll try to check if there is some kind of limitation on that screen.
Regards,
Happy to help!
Thank you @ibarrau @v-eachen-msft for the answer!
Although I still don't know why that limit occurs, with SQL I have found the table.
Regards
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.