Hi @joaofms
It is a data source error which means it cannot find the object "sys.extended_properties". Did you connect to the SQL Server data source with a native SQL query? If so, can you use the same query to query the data successfully through client tools like SSMS?
One possible cause is that your database is case sensitive so you need to make sure the name is completely consistent with that in the database. See Invalid object name 'SYS.EXTENDED_PROPERTIES' on binary collated databases (microsoft.com)
If you didn't have any problem with this report before this Tuesday and didn't make any change to the data source settings in the report, can you check if you still have the permissions to the system catalog views? The visibility of the metadata in catalog views is limited to securables that a user either owns or on which the user has been granted some permission. If your permissions have been removed, you may be not able to see it. See sys.extended_properties (Transact-SQL) - SQL Server | Microsoft Docs
I suggest that you can use SSMS to test your connection and query data from the same data source. If you have the same error in SSMS, so you need to fix it at the source side. If you don't have the same error in SSMS, you can try creating a new blank Power BI report and connecting to the same data source to check whether it's an error only existing in a specific report or in all reports.
In addition, this is another similar thread that may be helpful: sql server - Getting an error "Object is invalid. Extended properties are not permitted" error when ...
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
