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
borutsustar
Helper I
Helper I

Using Web datasource automatically add transformation steps with new version of Power BI Desktop

Hi.

 

I recently updated Power BI Desktop. I noticed diffrent behaviour when i connect to web datasource in Power Query. Namely, when first connect to web datasource, Power Query automatically add addtitional transformation steps (convert to table, expantd records, changes types of columns,...). With the older version of the Power BI desktop, only one step was created on the first connection to the web data source.

Is there any setting in Power BI Desktop that would disable the automatic creation of transformation steps after the first connection to web data source?

 

Borut

2 REPLIES 2
edhans
Super User
Super User

I don't believe so. You can try the Type Detection setting in the Global/Data Load area. But MS redid the web connector a year or so ago. You can always delete the steps you don't want, but the goal was to make it at intuitive and easy for the average user so less embedded things for most people to deal with (embedded tables, lists, etc)



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

Hi.

 

Hm, Type Detection settings only remove "Change Type" steps. 

 

In my case, I am using web access to REST API from Jira. When i first connect to some API, i get, for example, 40 steps of expanded actions. So, it gives me all the data from the API, which I don't want. I need to limit the data set because I don't need all the data from API. I also have preformance problems if I use all the transformation steps and data and eventually kill Jira server.

Yes, i can delete additional steps or open blank query and write some M code in it to avoit this situations, but this is not practical. The problem is that I don’t know all the data returned by the API, so I need to research step by step which data to use. In this case, i must delete all the additional steps and begin with custom steps to research the data.

Ok, this is not a disaster, but it would be much better if there was a possibility to turn off/on this feature in Power BI Desktop (Dataflow). I hope MS will fix this in the future.

 

 

Helpful resources

Announcements
Europe Fabric Conference

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.

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.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

Top Solution Authors
Top Kudoed Authors