Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Valid PowerPlatform.Dataflows code causes error box #936

Closed
edhans opened this issue Jun 29, 2023 · 1 comment
Closed

Valid PowerPlatform.Dataflows code causes error box #936

edhans opened this issue Jun 29, 2023 · 1 comment
Assignees
Labels
issue: bug Confirmed as a bug in TE3
Milestone

Comments

@edhans
Copy link

edhans commented Jun 29, 2023

Describe the issue
I created an M query using Power Query online in a dataflow and generated good code, but when I tried to update the table schema I got this error:

image

The M code generated was this:

let
Source = PowerPlatform.Dataflows([]),
Navigation = Source{[Id = "Workspaces"]}[Data],
#"Navigation 1" = Navigation{[workspaceId = "xxxxxxxxxxxxxxxx"]}[Data],
#"Navigation 2" = #"Navigation 1"{[dataflowId = "xxxxxxxxxxxxxxxxxxxxxx"]}[Data],
#"Navigation 3" = #"Navigation 2"{[entity = "Sales", version = ""]}[Data],
#"Changed column type" = Table.TransformColumnTypes(#"Navigation 3", {{"Unit Price", Currency.Type}, {"Net Price", Currency.Type}, {"Unit Cost", Currency.Type}})
in
#"Changed column type"

By changing the first line to this:
Source = PowerPlatform.Dataflows()

it fixed the issue - removing the square brackets from inside the parenthesis.

** Which version are you currently using? **
Tabular Editor 3, version: 3.8
Tabular Editor 3 edition: Enterprise

To Reproduce
Power BI Service

Steps to reproduce the behavior:

  1. Create a simple connection to a Power Platform dataflow in PQO
  2. Create new M partition table in TE3
  3. Paste the M code in the Partition expression
  4. Update Table Schema

Error shows up.

@otykier otykier added the issue: bug Confirmed as a bug in TE3 label Jul 4, 2023
@otykier otykier added this to the 3.9.0 milestone Jul 14, 2023
@DBojsen DBojsen self-assigned this Jul 18, 2023
@DBojsen
Copy link
Collaborator

DBojsen commented Jul 24, 2023

Hi @edhans

This is now fixed in 3.9.0.
Thanks for reporting.

BR David - TE3 Support

@DBojsen DBojsen closed this as completed Jul 24, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
issue: bug Confirmed as a bug in TE3
Development

No branches or pull requests

3 participants