Power BI Report Builder how to join another dataset and bring a column from dataset A to dataset B
I have a simplified scenario where there are 2 datasets in Power BI report builder. Dataset A is relatively simple which is a SQL query and the result of which gives Store_ID
and Store_Name
. Dataset B is a stored procedure (in reality it’s very complicated and hard to convert to a SQL query) which takes two parameters (Start_Date
and End_Date
) and it returns Store_ID
, Sales
and etc.