When using the New Entities from Data (Technical Preview) feature, you might run into an error that looks like the following:
*Unable to create or retrieve a mashup for the current database*
This can occur when you're using the feature to create Custom Entities in the Common Data Service (CDS) based on data from external data sources using Power Query. The error is triggered when Power Query cannot access the organization's data in PowerApps or CDS. There are two scenarios when this can happen:
There are two ways to fix the issue described above:
Each of the steps necessary for these solutions are described next.
You can contact the AAD tenant administrator, and have him or her perform the following steps, which enables users to consent to any app accessing company data:
This is perhaps the easiest approach, but it allows for broader permissions than the next option.
Another solution is to have the tenant administrator give consent to Power Query without modifying tenant-wide permissions. Have the tenant administrator take the following steps achieve this:
The advantage of this approach (versus the tenant-wide solution) is that this solution is very targeted. It provisions only the Power Query service principal, but no other permission changes are made to the tenant.