Forum Discussion
Helper IVPower BI Desktop connect to multiple datasets as Direct Query - can I filter pre-connecting?
Hi all,
I need to connect to multiple Power BI Datasets which are in the Service. For example below is one of them:
Is there a way to filter for example "15 Month Rev" table before connecting to it? I wanted to filter a column and only connect to the selected dataset.
Not sure if there is an option. Thanks.
Hi Winniethewinner ,
No, you can't filter an already published dataset and then use it.
Couple of alternatives :1. Connect to the published dataset and then create a filter calculated table using DAX
2. Make a copy of the report/dataset and then filter it
Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!!
Proud To Be a Super User !!!
LinkedIn
2 Replies
- Anand24
Super User
Hi Winniethewinner ,
No, you can't filter an already published dataset and then use it.
Couple of alternatives :1. Connect to the published dataset and then create a filter calculated table using DAX
2. Make a copy of the report/dataset and then filter it
Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!!
Proud To Be a Super User !!!
LinkedIn
WinniethewinnerThanks Anand24 , can you elaborate more on the first option - the DAX for a calculated table? Also, will it impact the performance as I'm connecting to multiple datasets via Direct Query. Thank you