I've been trying to recreate some of my initial PowerQuery scripts into re-usable Dataflows on the PowerBI Service (using PowerQuery online rather than the desktop instance). In one of my scripts, I get the below error when trying to do scheduled refreshes or even on-demand refreshes. I do not get this error when initially writing the script within PowerQuery online, only when refreshing. I also do not get this error when it's written as part of my old Power Query and refreshed via a scheduled dataset refresh.... So it's something to do with writing it and refreshing within Dataflows specifically.
Error: Expression.Error: We couldn't convert to Logical. Request ID: 3c8a42bf-2c49-a85c-a102-6b8d857e633a Activity ID: fc541a08-7902-40c3-9818-e6498c883f0a
At the end of my code, I do convert a column to a Logical but I don't see why this is causing an issue...?
There are dataflow limitations but they don't seem to apply in your scenario.
If you have a Pro license you can consider raising a Pro ticket at https://powerbi.microsoft.com/en-us/support/pro/
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!
User | Count |
---|---|
38 | |
26 | |
20 | |
19 | |
10 |
User | Count |
---|---|
55 | |
26 | |
19 | |
13 | |
13 |