Power BI - Cosmos DB V2 Connector - Heterogenous Schema

Hi Dino,

Thanks for the reply.  You’re suggestions were not able to solve my problem.

Enabling profiling on the whole dataset is to allow profiling of values within a column on a whole dataset.  I’m not needing to know all values within a column, but instead I need to know all columns within a dataset.  In my case some columns are not displaying, because they are not present within the first 1000 Cosmos documents.

Regarding your second point.  I checked and see the native query option is greyed out.  What’s interesting, is that there are two Cosmos connection options in PBI.  The V1 and V2.  The V1 option doesn’t allow DirectQuery mode, but does allow the option to provide a sql statement.  However, in both cases, I’m not able to see the native query option, even though in V1 you can provide a sql query.

M code for V1

M code for V2

Is there a way to introduce a sql query in the V2 connector? If so, what’s the syntax, as I’ve tried a number of different ways with no luck.