You’re offline. This is a read only version of the page.
Announcements
Hi.
I have created a flow which refreshes a power Bi dataset based on what is returned from a sql stored procedure.
Execute Stored procedure (V2) returns OutputValue = 1
Next action is Compose for which the Input is resultsets of the Stored Procedure
Next action is Condition which is set to be TRUE if the Outputs of Compose is equal to 1
The flow runs successfully but it doesnt follow the correct path, the dataset should refresh but it follows false.
Can anybody help with what I doing wrong? Any help would be appreciated, I have tried creating a variable after the stored procedure but get the same result.
Chris.
Hi @FLASHChris ,
Sometimes the flow output shows 1, but it is actually 1.000.
I suggest you try some functions, such as int and string, to check the difference between values on both sides of the condition.
Best Regards,
Wearsky
Share
Report
All responses (
Answers (
538
