I have this same question - I'm trying to add a non-spatial SQL table to a dashboard. How do I share the table as a service in pro? The only way I've found is to make it a hosted table, but that makes the data static. I've added it to a map as a query layer, can I publish it without having other map data in my map?
If I try to publish it as a web map from pro to portal - it publishes, but the table is just dropped.
If I try to publish it as a web layer - it gives me an error "Map does not have layers"
If I try to publish it as a table directly, it only gives me the option to share it as a hosted table.
How do I publish it as a registered table so that I can add it to my dashboard?