You can translate the question and the replies:

Pass data values from Power BI to Denodo Views

I have a Dashboard in Power Bi where user can display reports per Month depending the date they select, is it posible to pass this value from Power BI to Denodo Final View (This view should filter information based on the date provided by user in Power BI)?? How can it be done?
user
20-01-2022 11:48:41 -0500
code

1 Answer

Hi, In general, it is possible to pass the values from Power BI to Denodo Virtual DataPort (VDP). For instance, if I want to pass the **date value** to the VDP view (final view) from the Power BI, then I would use the [**Power Query advanced editor**](https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-query-overview) option in the Power BI and provide the required value by doing the following steps: 1. Open the Power BI tool, load the corresponding view and click on the “Transform Data” button. 2. The view should open in a power query editor window. If not, then navigate to the Power Query Editor window. 3. In the Queries tab, click on the name of the corresponding view and then click on ‘Advanced Editor’. 4. In the Advanced Editor window, provide a value for the fields by using Power BI code. 5. You can do this by using the table function [**Table.SelectRows**](https://docs.microsoft.com/en-us/powerquery-m/table-selectrows) in Power Query. 6. Click “Done” to view the loaded data in the table. You can refer to the official [**Microsoft**](https://docs.microsoft.com/en-us/powerquery-m/table-selectrows) documentation, for more information. Alternatively, if your requirement is to pass the values as parameters, from Power BI to VDP, then refer to the official Microsoft documentation [**Using parameters**](https://docs.microsoft.com/en-us/power-query/power-query-query-parameters) for detailed information. This way, the filter conditions will be delegated to the VDP server from Power BI. Hope this helps!
Denodo Team
21-01-2022 06:48:36 -0500
code
You must sign in to add an answer. If you do not have an account, you can register here