Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateJoin the OneLake & Platform Admin teams for an ask US anything on July 16th. Join now.
Hi Guys,
I have a dataflow that I want to use to create another dataflow but I keep getting this error when I try to load the dataflow.
The MashUp Script:
---------- Message ----------
Expression.Error: We can't convert values of this type to JSON.
---------- Session ID ----------
a7a0579a-ca7c-4ed9-af09-4744c245ddc3
---------- Request ID ----------
35502f83-504f-452a-b21a-edd3d51739a1
---------- Mashup script ----------
[DefaultOutputDestination = "DefaultDestination"]
section Section1;
shared DefaultDestination = Lakehouse.Contents(null){[workspaceId = "97dfcda7-7f2c-4e30-a6c2-27e351e329d2"]}[Data]{[lakehouseId = "f4eaf6ce-7322-42b8-a220-e5d3e7b816be"]}[Data];
[BindToDefaultOutputDestination = true]
shared Query = let
Source = PowerPlatform.Dataflows([])
in
Source;
For anyone following this thread, it seems as though connecting to a dataflow only works if the destination dataflow is not a Gen2 dataflow.
From what I last heard from support, the internal team is trying to find a fix for this issue.
I am experiencing the same error and submitted a support ticket. If anyone has insight, that would be great!
Getting the same issue in my workspace.... was there every a solution found?
If it only happens with that single entity, it could be a corrupted entity or somethign that happened with that specific entity.
If it happens to every single entity that you're trying to connect to, then it might be a bigger issue.
Regardless, I'd recommend reaching out to the support team by raising a support ticket using the link below:
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Fabric update to learn about new features.