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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
Anonymous
Not applicable

Power Bi Report Builder using Power Bi Data Model

Hi All, I am using Power Bi report builder that is pointing to a PBI data model. 

 

When I click on Query Designer it sometimes shows me options to drag drop the required cols and sometimes it just shows me the option to write the DAX. When I then want to change this to Design Mode then I lose all my existing code. How can I stop this from happening please.

1 ACCEPTED SOLUTION
bradsy
Microsoft Employee
Microsoft Employee

Hi Sweets7,

 

That is the expected behavior. You can either use the UI designer for your query or the query editor text window. Not both together. 

 

One thing you might take a look at is this new feature: https://powerbi.microsoft.com/en-us/blog/get-data-with-power-query-available-in-power-bi-report-buil... 

View solution in original post

1 REPLY 1
bradsy
Microsoft Employee
Microsoft Employee

Hi Sweets7,

 

That is the expected behavior. You can either use the UI designer for your query or the query editor text window. Not both together. 

 

One thing you might take a look at is this new feature: https://powerbi.microsoft.com/en-us/blog/get-data-with-power-query-available-in-power-bi-report-buil... 

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

May 2025 Monthly Update

Fabric Community Update - May 2025

Find out what's new and trending in the Fabric community.