Power Platform usage for filtering DAX and M tables

[klehar]

Hi,

I have some parameters in Sharepoint that affect my report in M code as well as DAX.

I want to bring these parameters to Power BI via some interface so that the users don't have to switch to sharepoint to change thier parameters. These parameters cannot be brought to Power BI directly due to some limitations. I know we need to use other power platform tools. But not sure how. So I wanted a step wise explanation to tacke this problem.

Question 2:

I have a power bi pro license. What other licenses would I need to implement this change?

@amitchandak don't spam with links. Reply only if you have a solution.

[v-jayw-msft]

Hi @klehar ,

The tools I’m familiar with are PowerApps and Power Automate but I don’t think these two can interact with DAX or M.

All I can think about is to create parameters in Power BI but as you said there's some limitations so you can't do that.

Sorry for not helping you, hope others have a better solution.

Best Regards,

Jay