Forum Discussion

Anonymous

Not applicable

1 year ago

Solved

Pass slicer value to a TSQL query to pull data from SQL Server

HI I have a powerbi desktop that pulls data from both an existing powerbi model , and I also need to add data from a separate SQL Server data source. I havent done this before - can I please ...

kushanNa
1 year ago
Hi Anonymous

Yes you can pass values from a slicer to SQL query but you need to have that query in direct query mode

here is an example how to do it : https://www.youtube.com/watch?v=pXU_SpiBWUA&t=18s&ab_channel=DataPlatformCentral

Super User

1 year ago

Hi Anonymous

Yes you can pass values from a slicer to SQL query but you need to have that query in direct query mode

here is an example how to do it : https://www.youtube.com/watch?v=pXU_SpiBWUA&t=18s&ab_channel=DataPlatformCentral

v-achippa
Community Support
1 year ago
Hi Anonymous,

Thank you for reaching out to Microsoft Fabric Community.

Thank you kushanNa for the prompt response.

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the super user resolved your issue? or let us know if you need any further assistance.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Thanks and regards,

Anjan Kumar Chippa
- v-achippa
  Community Support
  1 year ago
  Hi @wokka,
  
  We wanted to kindly follow up to check if the solution provided by the super user resolved your issue.
  
  If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.
  
  Thanks and regards,
  
  Anjan Kumar Chippa
  - v-achippa
    Community Support
    1 year ago
    Hi @wokka,
    
    As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the super user resolved your issue.
    If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.
    
    Thanks and regards,
    
    Anjan Kumar Chippa

Related content