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
Sweets7
New Member

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors