Unable to delete table due to entityanalyticsconfig
Unable to delete table due to dependency on entityanalyticsconfig – this is how to fix it!
Utilize query from Marketing reports in data flows
Recently I needed to get the marketing insight replicated data from the data lake where it is replicated to, to Customer Insight. However, that turned out to not be very easy as the data had some formatting issues. However, I found that the Marketing reports that Microsoft have release for Power BI can be used as inspiration for how to query the data.
Bulk Delete failing
I have recently been working with a customer with a large (500+ GB dataverse db) production instance and we are attempting to cut this down quite a lot. The natural way of doing this is bulk delete but it seems that if the underlying SQL isn't up to speed, your jobs...
Long term Retention – now in Preview!
Long term storage for dataverse data is now in public preview! Please help out to test it!
Calculated columns + Azure Synapse Link != true
I was recently helping my colleague Ebba Linnea Nilsson with a support ticket with data not being propagated correctly from dataverse to a datalake via Azure Synapse Link. It turned out that this was all by design. A design that might not be what normal users would expect.
Data Flows with null in boolean
Working with Data Flows is a useful method of getting a variety of types of data into Customer Insight and also other places. It is very easy to work with but troubleshoot it can be rather tricky as I havn’t gotten any good error messages. In this case, that null-values in booleans aren’t supported.
Gustaf Westerlund
12xMVP, MSc EE
Working as consultant since version 1.2. Involved in between 150-200 projects. Founder and Principal Consultant at CRM-Konsulterna.