Have you tried turning it off and on again?IT Support
Dataverse connector in Power BI is all the rage: fast, efficient, understands metadata well, supports both Import and DirectQuery, makes sushi upon request, you name it. Except that sometimes it does not work. Try selecting account table, for example:
DataSource.Error: Microsoft SQL: Invalid object name 'dbo.FilteredAccountTDS'. RequestId: TDS;a2c61dc8-b400-4d34-b66f-3c30157f0a42;2 Time: 2021-01-20T05:24:22.7689085Z Details: DataSourceKind=CommonDataService DataSourcePath=foobar.crm6.dynamics.com Message=Invalid object name 'dbo.FilteredAccountTDS'. RequestId: TDS;a2c61dc8-b400-4d34-b66f-3c30157f0a42;2 Time: 2021-01-20T05:24:22.7689085Z ErrorCode=-2146232060 Number=40000 Class=16
If you try accessing it using SQL Server Management Studio, the result is pretty much the same:
What is this Filtered nonsense you’re talking about? I have no knowledge of this FilteredAccountTDS view, my dude.SQL Server on behalf of Dataverse
Support request raised, screens shared, emails exchanged. The solution, believe it or not, is in the best traditions of The IT Crowd. Seriously, go to Manage Feature Settings, turn TDS off then turn it back on. Rumor has it that there was an update applied recently and, if you had TDS enabled during that update, few things may have gone south. Flipping the switch fixes that.