Power bi Connector

[Sudharshan1919]

Hi All,

I am using power bi connector. Think of i am using a power bi teams connector, and there is very huge data in it, but i want to filter the data from the source itself. That means while connecting to the connector only, i need only a particular group of data. Is this really possible ?, If Yes then How can i do it.

Thanks

[amitchandak]

@Sudharshan1919 , I can see transform data while loading the data, You can add filter in power query

[Sudharshan1919]

No amit, not like that

Think if i am using Personal Teams connector, and when connected with connector.. then Transform Data option will be displyed, after going to Transform Data only we will be able to filter the required group of data.

But my case is without the Transform Data option, i.e if i belong to Group "Knights", i should be able to get only the Knights group data. Is it possible through Power BI Connector.