cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jwi1 Regular Visitor
Regular Visitor

Power BI datasets/ possible to modify

Good day dear Power BI friends,

in Power BI desktop, under the button 'get data', we have the option to choose for a 'power BI dataset'.

If I want to modify this dataset for my new dashboard, is this possible?

in my case I want to change a filter in one of the tables in the Power Query editor.

However, it is not possible to go to the editor as the 'edit query' butto is grey (disabled).

Thanks for your reply!

John

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Power BI datasets/ possible to modify

@jwi1 

 

you can update the dataset stored in PowerBI service, or perhaps remove this filter altogether from the dataset in the power bi service and then in your report you place a report level filter based on your scenario (valid or invalid)

 


 


Did I answer your question correctly? Mark my answer as a solution!


Proud to be a Datanaut!  

4 REPLIES 4
Super User
Super User

Re: Power BI datasets/ possible to modify

Hi @jwi1 

 

unfortunately this is not possible, this is the same connecting live to a SSAS Tabular model. What kind of filter do you need to apply?

 


 


Did I answer your question correctly? Mark my answer as a solution!


Proud to be a Datanaut!  

jwi1 Regular Visitor
Regular Visitor

Re: Power BI datasets/ possible to modify

Hi @LivioLanzo 

 

Thanks for your reply!

In the table, I have a column in whcich is defined if the row is valid or not (1 = valid - 2 is invalid)

in the table I added a filter, only the valid rows are shown.

 

is it maybe possible to adjust the  filter in the original file, after which it will become automatically valid in the 'new' file set as well?

 

John

Super User
Super User

Re: Power BI datasets/ possible to modify

@jwi1 

 

you can update the dataset stored in PowerBI service, or perhaps remove this filter altogether from the dataset in the power bi service and then in your report you place a report level filter based on your scenario (valid or invalid)

 


 


Did I answer your question correctly? Mark my answer as a solution!


Proud to be a Datanaut!  

Highlighted
jwi1 Regular Visitor
Regular Visitor

Re: Power BI datasets/ possible to modify

Hi @LivioLanzo.,

 

Yep, will try this, thanks!

 

John