Bug when combining files in dataflows

[Daniil]

Two bugs when combining files in dataflows (Folder connector):

1. If there are multiple sheets in Excel, the function and the sample transform query aren't synced. The function selects a specific sheet (you're forced to select a sheet -- see next point), while the sample function shows all sheets

2. Unlike Power BI Desktop, dataflows don't allow you to right-click Parameter in the Combine files dialog box and select Transform data. This is what I'm referring to:

The implication is that it's not possible to combine data from all sheets -- you're forced to select a sheet. Again, that's not an issue in Power BI Desktop, hence it's a bug.

[Anonymous]

Hi  @Daniil 

What do you mean by won't synchronize? Can you describe the situation specifically? Also, you mentioned that dataflows don't allow you to right-click Parameter in the Combine files dialog box and select Transform data, that is, currently PBI Service doesn't have PBI Desktop as a feature, right? What version of Desktop are you using?

Best Regards,
Community Support Team _ Ailsa Tao

[Daniil]

Re: "What do you mean by won't synchronize? Can you describe the situation specifically?"

I just connected to a folder of files in dataflows (Power BI service), selected Sheet1.

Notice that what I see in Transform Sample file and in Advanced editor is different.

Transform Sample file shows only the Source step, not Sheet1 specifically.

In Advanced editor, there's the Navigation step.

 

In Power BI Desktop, it's all correct, and has been correct for many years (it's not new functionality)