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
LivioLanzo Super Contributor
Super Contributor

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!  

View solution in original post

5 REPLIES 5
LivioLanzo Super Contributor
Super Contributor

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

LivioLanzo Super Contributor
Super Contributor

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!  

View solution in original post

jwi1 Regular Visitor
Regular Visitor

Re: Power BI datasets/ possible to modify

Hi @LivioLanzo.,

 

Yep, will try this, thanks!

 

John

anandgavle New Member
New Member

Power BI datasets & Report Usage Metrics Model Modification

HI Team,

 

Once we open the power bi desktop file thenclick on GetData-->Power BI Datasets-->Under Workspace-->Report Usage Metrics Model.

We will get some defualt tables related to metrics i,e ex: Dates,DistributionMethods,Platforms,Reports,ReportCount,ViewersRankings,Views and ViewsRanking.

Here i am not able to see the relationship between those entities and everything is getting disable like our direct query tabular model.Please let me know how can i get the relationship and shource table becuase i want to add two more tables there in that model .Please suggest.

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (4,156)