The TDS endpoint (which is what SQL Management Studio and Power BI connect to) does not support virtual tables or the audit table, at this time, per the documentation. I recommend trying the SQL2CDS plugin for XRMToolbox. This should allow you to get the experience of SSMS on the virtual tables as it will use […]
Model-driven Apps run only on Dataverse (formerly Common Data Service) entities, thus you cannot directly reference a SharePoint list. You can recreate the list as a Dataverse Table (formerly Entity). Then you could use Power Automate to keep the two lists synchronized. If the list will be read-only in the Model-driven App this will be […]
You need to use the integer property, not the label value, because the value passed from Dataverse for the statuscode field is going to be an integer value. You can find the integer value by looking at the field in the Power Apps Maker portal.
This is the expected functionality. When you create a Dataverse database in an environment all licensed users will be added. Users do not have any access to the database unless you assign them a security role. Once a user is added to the Dataverse database that user record cannot be deleted. They can be inactivated, […]
In PowerBI you can create a data alert to send you a notification. By default, the data alert is an in-app alert but there is in an option to have it also send you an email. Unfortunately, there is no capability in PowerBI to set an alert for another user. You can use a Power […]