Dataflows message "Please specify how to connect." when trying to reproduce Get Data > Folder

[mmace1]

Hi, 

I'm trying to reproduce the Get Data > Folder functionality from PBI Desktop, in Dataflows, using the Blank Query functionality. 

I know from the below thread, that I need to reproduce all of the queries / parameters / folders / etc. that I have in PBI Desktop.

https://community.powerbi.com/t5/Power-Query/How-to-Combine-Files-in-SharePoint-Folder-with-a-Datafl...

However, when trying in DataFlows, I keep getting a "Please specify how to connect" dialogue for all of my queries.  I enter in my credentials, and it just reappears. 


My Gateway seems otherwise fine - 

I'm able to update datasets using my gateway
I'm able to create a sucessful test dataflow (just connecting to a local .txt. file) fine.

[v-frfei-msft]

Hi @mmace1 ,

You should add all the query to the group.

[mmace1]

So I have added the folders.  

[v-frfei-msft]

Hi @mmace1 ,

The sample file parameter is still missing in your scenario. Please check it again.

[mmace1]

Updated.  So, these 2 are, sorry for my ignorance- the wrong icon, so I assume not being interpreted as the correct type of object? 

[v-frfei-msft]

 not being interpreted as the correct type of object? 

---

What does that mean?

[v-frfei-msft]

Hi @mmace1 ,

Has your issue been solved? If so, kindly mark my answer as a solution to close the case. If any other question, feel free to let me know please.

[mmace1]

Thanks, my last post did still have a question in it.  

[v-frfei-msft]

Hi @mmace1 ,

Inside the entity we should create groups of queries by right-clicking the "blank field to the left" and pressing new group. The groups should be identical to the groups created in Power BI Desktop.

let
  Source = SharePoint.Files("https://xxx.sharepoint.com/sites/asnew", [ApiVersion = 15]),
  #"Filtered Rows" = Table.SelectRows(Source, each ([Name] <> "Capture.PNG")),
  #"Filtered Hidden Files1" = Table.SelectRows(#"Filtered Rows", each [Attributes]?[Hidden]? <> true),
  #"Invoke Custom Function1" = Table.AddColumn(#"Filtered Hidden Files1", "Transform File from Query1", each #"Transform File from Query1"([Content])),
  #"Renamed Columns1" = Table.RenameColumns(#"Invoke Custom Function1", {"Name", "Source.Name"}),
  #"Removed Other Columns1" = Table.SelectColumns(#"Renamed Columns1", {"Source.Name", "Transform File from Query1"}),
  #"Expanded Table Column1" = Table.ExpandTableColumn(#"Removed Other Columns1", "Transform File from Query1", Table.ColumnNames(#"Transform File from Query1"(#"Sample File"))),
  #"Changed Type" = Table.TransformColumnTypes(#"Expanded Table Column1", {{"Source.Name", type text}, {"Date", type date}, {"cat", type text}, {"Sales", Int64.Type}})
in
  #"Changed Type"

[mmace1]

I think I am, or do you mean, I'm doing that somehow incorrectly, and that's resulting in the "Please specify how to connect" error message?