Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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.
Hi @mmace1 ,
You should add all the query to the group.
So I have added the folders.
Hi @mmace1 ,
The sample file parameter is still missing in your scenario. Please check it again.
Updated. So, these 2 are, sorry for my ignorance- the wrong icon, so I assume not being interpreted as the correct type of object?
not being interpreted as the correct type of object?
What does that mean?
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.
Thanks, my last post did still have a question in it.
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"
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.