PowerBI challenges

[pavan1]

Hi All,

I have faced the following challenges in the project Development, can any one answer the below question how to implement in power bi desktop.

1) How to pass mutivalue parameter in Power BI desktop?

2) Direct query connection to sql server azure supporting  calculations or not?

3) How to switch between one report to other using power BI Desktop?

4) How to change or parameterize the  database name dynamically without manual intervention.

Regards,

J Pavan

[hohlick]

hi @pavan1

what do you mean by multivalue parameter? A parameter which consists of several field-value pairs?

[Eric_Zhang]

@pavan1

1.  AFAIK, there's no way to pass multiple parameter values
2. If you mean the limited measures in DirectQuery mode, you can enable them by "File"->"Options and settings"->"Options"->"DirectQuery"->"Allow unrestricted measures in DQ mode"
3. No way to switch one report to another
4. No way without manual intervention.

You requirement is confusing me, may I know what exactly you'd like to do with Power BI?