Q&A BY TAG 'Power BI'
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 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
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 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 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
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
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 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
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