Forum Discussion
DirectQuery in Composite Model
Hi. I have a composite model with direct queries that looks like this When I try to make a table visual with user_action metrics and aggregation by country, I get the following error: OLE DB ...
Update:
After some investigation I discovered that during my change to the formatting I accidentally changed the data type of some of the fields in one of my tables which was part of the join. Although the modified fields were not keys used in the join it was enough to trigger this particular error. Upon restoring the types to their correct settings my visuals started working again.
Aside: The reason why I accidentally changed the type of some fields was due to an issue where filtering the fields and selecting multiple fields using shift still selected the fields that were not visible. I assume this is a bug.