Power BI Report Builder DAX query

Question

I have a paginated report that which i am using Power Bi Report Builder but i have many different columns that are lookups to other columns how can i apprach them on a expression. My datasource is Dataverse.&nbsp;

patty789 · Answer

GilbertQ&nbsp; I am not sure how to achive that.&nbsp;&nbsp;

gilbertq · Answer

Hi&nbsp;patty789&nbsp;
&nbsp;
You should be able to use the expression editor when creating the dataset to get the columns you need?

gilbertq · Answer

Hi&nbsp;patty789&nbsp;
&nbsp;
That is the dataset settings once the dataset is created?
You would need to do this when you create the dataset?

v-luwang-msft · Answer

Hi&nbsp;patty789&nbsp;,
Refer the following article ,and check if it is helpful .
Write DAX queries in Report Builder #ssrs #dax #ssas #tabular
SQL Server Reporting Services Report Builder with DAX Query Support
&nbsp;
&nbsp;
Best Regards,
Lucien

v-luwang-msft · Answer

Hi&nbsp;patty789&nbsp;,
Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.
Best RegardsLucien

Forum Discussion

Power BI Report Builder DAX query

5 Replies

Related content

Power BI Report Builder

Report Builder - Export failed

Power BI Report Builder: Cannot access report parameters inside Power Query (M language)

PowerBI Report builder

Power BI Dataset RLS - Power BI Report Builder