DataSet> PowerBI Report Builder - Not possible to extract list of objects from Table

[RodoLuxo]

Dear All,

I need your help concerning the following issue:

1-Here my MongoDB Table definition:

DB_PDS_ITEM:

company

employee

TableOfBonus

2-When i create a dataset:

I insert into the query: select * from DB_PDS_ITEM

When i click on Query Designer  and Run, i see only company and employee.

But NOT TableOfBonus

=> it seems that it is not possible to display a list of values from a table.

How can i achieve that ?

It works perfectly with PowerBiDesktop.

Thanks for reading, thinking and helping !

Rodolphe

[v-jingzhang]

Hi @RodoLuxo 

Paginated reports natively support both relational and analytic data sources. Since MongoDB is a NoSQL database, the data structure might be different from traditional relational databases. In this case, TableOfBonus might have a not supported data type so it cannot be loaded into Power BI Report Builder successfully. 

Data retrieval guidance for paginated reports - Power BI | Microsoft Learn

Supported data sources for Power BI paginated reports - Power BI | Microsoft Learn

Data types in expressions in a paginated report - Microsoft Report Builder & Power BI Report Builder...

Since it works perfectly with PowerBIDesktop, you may use Power BI Desktop to get data from the database and transform it into a friendly format. Then publish the pbix file into Power BI Service to have a dataset. Then in Power BI Report Builder, connect to this Power BI dataset to create a paginated report. This could be a workaround. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.