Forum Discussion

BalaVenuGopal's avatar
BalaVenuGopal
Icon for Resolver I rankResolver I
8 years ago

Passing parameter to sql from dropdown list in powerBI (Very interesting and challenging)

Dear All, My requiremnt is to send parameter to sql but i need drop down to choose valeu Table Info : Assume I have tabel(Emp_Info) with columns [EmpName,Location,salary] Requiremnt : My table hav...
Need Help
v-chuncz-msft's avatar
v-chuncz-msft
Icon for Community Support rankCommunity Support
8 years ago

BalaVenuGopal,

 

Make sure you use the Import mode and set parameter Type to Text. For DirectQuery mode, use a Slicer instead.

  • BalaVenuGopal's avatar
    BalaVenuGopal
    Icon for Resolver I rankResolver I
    8 years ago

    Hi v-chuncz-msft

    Thank you for your reply. Could you plese explain in detailed , I am planing to load data from sql to powerbi data model with filter but slicers will appear at report level correct so how can i make use of slicers here