My Power BI report is built on Azure Synapse using a View. Initially there was no issue. But as the number of tables and views count increased in the database, I am unable to view all the views or tables of the database in the Power BI Navigator.
Now the existing View which is used in the report and a new view which needs to be used in the report, both are not visible in the Power BI desktop navigator. The top 10000 tables and Views are displayed in the alphabetical order and the others are not.
Even the search string is also not working.
Can someone please help with this issue.