Table is Empty when Connecting to a View in Azure SQL Database from Power BI

Hi m196804 ,

First, please ensure that the credentials used in Power BI to access the Azure SQL Server have the necessary permissions to view the data in the SQL Server views. Sometimes, permissions might be set correctly for tables but not for views.
And please review the configuration and optimization of your Azure SQL Server views. Ensure they are efficiently designed for Power BI consumption. This includes checking for any complex calculations or aggregations within the views that might be optimized or pre-aggregated.
If your Power BI model uses complex Power Query queries to transform data from Azure SQL Server views, consider simplifying them. Power BI works best with queries that map directly to a single relational database source table or view without requiring transformations. Complex queries might not map correctly to the underlying views, leading to data not showing up.

If the above steps do not resolve your issue, could you please provide the following information to further assist you?

Have there been any recent changes to the views or the database schema?
Are you able to preview data from these views in Power Query Editor before the refresh, or does it show "no data" immediately?
What version of Power BI Desktop are you using?

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.