Latest Activity

code

Connecting Denodo views with parameters to Power BI.

I've been working with a few Denodo views and am looking to bring the final view into Power BI. However, I need to somehow define the required parameters as I'm connecting the view or else Power BI will return an error. I would like to connect these de...

Power BI Parameter Power Query

code

Denodo function equivalent to Table.AddIndexColumn Power BI function

Does Denodo have a function that is equivalent to the Table.AddIndexColumn Power Query function that one can use in Power BI? See: https://learn.microsoft.com/en-us/powerquery-m/table-addindexcolumn

Power BI #Denodo

code

Best practice to handle Denodo parameters in PowerBI

Hi, Please advise on what the best practice is to use Power BI to query parameterized views on Denodo (I'm using ODBC). Where I select a parameterized view from the Power BI navigator / selector I get an ODBC error : No search methods ready to be run....

Power BI Paramaterised Query

code

Power BI reports - Creates multiple queries

Using the latest Denodo 8.0 with the patch released this Aug. Question is, we seem to be having multiple queries that are exactly same in Denodo Query monitor when we run a report from Power BI. Why does it create same queries in Denodo? Is there a re...

Power BI ODBC connection with Entity Framework

code

How to restrict results returned in PowerBI using a parameter?

we have a table in denodo with a time dimension, can we restrict the number of results using a parameter in PowerBI?

Power BI Parameter

code

Power BI dashboard report with Dax queries are performing slow on Denodo

I am having slow performance issue in Power BI dashboard built on top of denodo. Denodo is on top of HANA. Trying to figure out where it went wrong. One of the PBI dashboard built on top of Denodo is taking 16 sec to show the data. There are 20+ que...

Power BI Slow Query Response DAX formulas

code

Power BI with Denodo

Hi Team, We are trying to integrate denodo with power bi where in denodo is hosted in aws. We are trying the web based integration from get data option but we are unable to get the login screen for denodo. Thankyou.

#powerBI connection #Denodo-PowerBI Power BI Denodo Design Studio

code

Interpolation Variable with Power BI

I have created final view with interpolation variable. I would like to use this final view in power BI. I need to pass value to the interpolation variable from power bi report and load only the particular dataset to the model. How can I achieve this

Interpolation Variables Power BI

code

Direct Query in Power BI Dashboard is not working

Hi and thank you for read this. I did a connection between a view in the Denodo Data Catalog and Power BI Desktop data set through a gateway selecting the Direct Query import option. Then I upload my data set and dashboard to the Power BI Service. I st...

Power BI Dashboard Direct Query Power BI Service

code

Power BI Direct Query Sample

Looking for a Power Bi Direct Query SQL example to enter into the advanced options SQL Statement. More info: Denodo is linked to a view on MSSQL Aveva Historian Runtime.Events table. https://www.aveva.com/en/products/historian/ The MS SQL is the the f...

Power BI Historian