Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
jwi1
Post Patron
Post Patron

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

@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
Anonymous
Not applicable

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.

LivioLanzo
Solution Sage
Solution Sage

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!  

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

@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!  

Hi @LivioLanzo.,

 

Yep, will try this, thanks!

 

John

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.