Forum Discussion

pavan1's avatar
pavan1
Helper I
9 years ago

PowerBI challenges

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

 

 

Need Help

2 Replies

  • Eric_Zhang's avatar
    Eric_Zhang
    Microsoft Employee
    9 years ago

    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? 

  • hohlick's avatar
    hohlick
    Continued Contributor
    9 years ago

    hi pavan1

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