Q&A BY TAG 'Power BI'

You must sign in to ask a question. If you do not have an account, you can register here

Best practice to handle Denodo parameters in PowerBI
answered 09-11-2022 13:37:39 -0500

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....

Answers: 1

Power BI Paramaterised Query

Power BI reports - Creates multiple queries
answered 27-10-2022 16:56:48 -0400

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...

Answers: 2

Power BI ODBC connection with Entity Framework

How to restrict results returned in PowerBI using a parameter?
answered 04-05-2022 12:25:18 -0400

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

Answers: 1

Power BI Parameter

Power BI dashboard report with Dax queries are performing slow on Denodo
answered 11-02-2022 05:03:57 -0500

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...

Answers: 1

Power BI Slow Query Response DAX formulas

Power BI with Denodo
answered 10-01-2022 08:25:33 -0500

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.

Answers: 3

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

Interpolation Variable with Power BI
answered 20-12-2021 04:22:23 -0500

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

Answers: 1

Interpolation Variables Power BI

Connecting Denodo views with parameters to Power BI.
answered 29-07-2021 17:03:26 -0400

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...

Answers: 2

Power BI Parameter Power Query

Direct Query in Power BI Dashboard is not working
answered 16-04-2021 07:24:51 -0400

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...

Answers: 1

Power BI Dashboard Direct Query Power BI Service

Power BI Direct Query Sample
answered 21-08-2020 03:03:02 -0400

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...

Answers: 1

Power BI Historian

Unable to use Power BI Denodo connector for views with column restrictions
answered 25-09-2019 08:58:07 -0400

We are utilizing 7.0, update 20181011. Power BI users that do not have access to all columns of a view are unable to utilize the Denodo connector. They see an error due to the fact that not all of the columns can be projected and they can not get to th...

Answers: 3

Power BI