Forum Discussion
Composite Model(Direct Query) Error
When I convert the live connection(SQL Database) to Direct Query using transform data, every visual fails and throws an error: "OLE DB or ODBC error : The 'NestingLevel' property was not recognized.....
After days of digging, I found the reason....currently composite model feature is available for azure and Power BI datasets and not SSAS cubsets,hence this feature isn't working. Hopefully, composite model support is extended to more database types in future.
After days of digging, I found the reason....currently composite model feature is available for azure and Power BI datasets and not SSAS cubsets,hence this feature isn't working. Hopefully, composite model support is extended to more database types in future.