Forum Discussion
DataSet> PowerBI Report Builder - Not possible to extract list of objects from Table
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
1 Reply
v-jingzhangCommunity Support
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
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.