Denodo community Q&A RSS feed https://community.denodo.com/answers//feed/rss Latest Denodo community answered questions row limit reached https://community.denodo.com/answers/question/details?questionId=906Qj00000kbbhGIAQ&title=row+limit+reached Good morning, The views I am currently editing are limited to 10 000 rows. When looking at the execution plan I got indeed the info that a setup limits the number of rows. I am checking where this setup could be amended. I did not find where to correct the view in order to not be limited in the number of displayed rows. The indication I was given to go through the VDP\tools\admin_tools_preferences\connection does not show any option to modify this limit. Could you indicate me how to solve that ? Thanks! Best Regards! Frédéric Cousin Fri, 07 Nov 2025 10:09:18 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000kbbhGIAQ&title=row+limit+reached 2025-11-07T10:09:18Z Derived Views Automatic https://community.denodo.com/answers/question/details?questionId=906Qj00000kUl5SIAS&title=Derived+Views+Automatic Hi , Does Denodo provide any script /APIs for automatic creation of derived views from base views having joins. Wed, 05 Nov 2025 06:29:15 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000kUl5SIAS&title=Derived+Views+Automatic 2025-11-05T06:29:15Z Connecting power Bi with denodo https://community.denodo.com/answers/question/details?questionId=906Qj00000kUyttIAC&title=Connecting+power+Bi+with+denodo I've been trying to connect power Bi with denodo using OBDC driver. Denodo is on my local machine, ive installed the OBDC driver and created dsn and when i try to connect with denodo, it just keeps loading or gives error saying server cloed unexpectedly [08001]. What could be the issue?! Wed, 05 Nov 2025 06:05:34 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000kUyttIAC&title=Connecting+power+Bi+with+denodo 2025-11-05T06:05:34Z Enable MFA https://community.denodo.com/answers/question/details?questionId=906Qj00000kRR1dIAG&title=Enable+MFA How to add a user in MFA. Tue, 04 Nov 2025 03:48:24 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000kRR1dIAG&title=Enable+MFA 2025-11-04T03:48:24Z How to rewrite group_concat? https://community.denodo.com/answers/question/details?questionId=906Qj00000k9OqEIAU&title=How+to+rewrite+group_concat%3F Hello Team, I have a usecase which is using group_concat in Denodo to implement listagg of oracle. When executing the Denodo entity, the whole query couldn't delegate to the data source â?? oracle. It has to be processed in Denodo server. In order to put processing pressure to data source rather in Denodo server, do we have any other options to implement the function like group_concat? Then all queries can be delegated to data source to release the capacity of Denodo server? Thanks Thu, 30 Oct 2025 08:42:50 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000k9OqEIAU&title=How+to+rewrite+group_concat%3F 2025-10-30T08:42:50Z Automation of creating Base views from a source having multiple tables. https://community.denodo.com/answers/question/details?questionId=906Qj00000k3D9VIAU&title=Automation+of+creating+Base+views+from+a+source+having+multiple+tables. Hi Team, I have a scenario, where I have a JDBC DataSource at Denodo end. Now, In the source poinitng by this Datasource there are many tables are creating on daily basis. So, I want to know that is there any way in Denodo where we can create Base views for all those source tables via some automation. Below steps need to be perform - 1. Connect the JDBC Datasource 2. Get the tables details from source 3. check in Denodo if the Base view for that table is already created or not. 4. If not, then create the same by following some predefined nomenclature 5. If yes, then drop it and recreate the base view. Please share some sample code and what needs to be done to achive this. Thank You, Mansi Saxena Wed, 29 Oct 2025 11:51:36 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000k3D9VIAU&title=Automation+of+creating+Base+views+from+a+source+having+multiple+tables. 2025-10-29T11:51:36Z PBI report connection using Azure VNet instead on-prem gateway https://community.denodo.com/answers/question/details?questionId=906Qj00000jtVCXIA2&title=PBI+report+connection+using+Azure+VNet+instead+on-prem+gateway Hi Denodo Team, We have PBI reports currently connection configured with on-prem gateway connection which was installed on VDP server. Now we want to change the connection from on-prem gateway to VNet. could you please let us know the steps involved in that , if that is possible. Thanks, Denodo Customer. Mon, 27 Oct 2025 18:44:41 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000jtVCXIA2&title=PBI+report+connection+using+Azure+VNet+instead+on-prem+gateway 2025-10-27T18:44:41Z problem with credentials https://community.denodo.com/answers/question/details?questionId=906Qj00000jrtSfIAI&title=problem+with+credentials Try to acces to de vdp or to the web service and it says i have an incorrect user or password, but in the web I can log in with the same username and password I was using Mon, 27 Oct 2025 15:44:14 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000jrtSfIAI&title=problem+with+credentials 2025-10-27T15:44:14Z PowerBI dataset as Datasource in Denodo https://community.denodo.com/answers/question/details?questionId=906Qj00000jVZZ3IAO&title=PowerBI+dataset+as+Datasource+in+Denodo Hello, We need to consume a PowerBI dataset, meaning the dataset would be a Datasource in Denodo. Do you know if this is possible and if so, what mechanism should be applied, please? Wed, 22 Oct 2025 15:02:49 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000jVZZ3IAO&title=PowerBI+dataset+as+Datasource+in+Denodo 2025-10-22T15:02:49Z OpenAPI specification for Denodo data REST API https://community.denodo.com/answers/question/details?questionId=906Qj00000jMcvxIAC&title=OpenAPI+specification+for+Denodo+data+REST+API Hi Team, We are using DENODO REST API to expose the data to one of Vendor but as part of security testing we need OpenAPI specification for these RESt API's.I see Swagger API iND enodo platform only.Is there a simple way to get OpenAPI specification for Denodo RESt API's. Thanks in Advance. Reagrds Venkata Tue, 21 Oct 2025 06:36:02 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000jMcvxIAC&title=OpenAPI+specification+for+Denodo+data+REST+API 2025-10-21T06:36:02Z