topic Power BI in Developer

Power BI

NightSpeedOne — Thu, 19 Dec 2024 14:55:16 GMT

I am trying to use a value passed from Power BI to Power Apps and based on that value navigate to the correct screen. The issue is that, even though I can see the value and display it with a Notify without the navigate, as soon as I add the Navigate(), I lose the value. I also tried the StartScreen.

###OnStart

Set(varPBIScreenId,

If(

IsBlank(

Text(First([@@PowerBIIntegratio].Data).Screen)

"0",

Text(First([@PowerBIIntegration].Data).Screen)

)

);

If(

varPBIScreenId = "1",

Navigate(PAM_Profile_User),

varPBIScreenId = "2",

Navigate(PAM_Absence_Patch),

varPBIScreenId = "3",

Navigate(PAM_Profile_SideList),

Navigate(PAM_Absence_Patch)

);

#### StartScreen

If(
Value(First([@PowerBIIntegration].Data).Screen) = 1,
PAM_Profile_User,
Value(First([@PowerBIIntegration].Data).Screen) = 2,
PAM_Absence_Patch,
Value(First([@PowerBIIntegration].Data).Screen) = 3,
PAM_Profile_SideList,
PAM_Profile_SideList
)

Re: Power BI

lbendlin — Thu, 19 Dec 2024 17:43:08 GMT

a value passed from Power BI to Power Apps

How are you passing that value? Via the PowerApps visual?

Re: Power BI

NightSpeedOne — Fri, 20 Dec 2024 11:51:51 GMT

Using the Power BI intergrated visual for Power Apps, insert the visual and then navigate to the power apps and edit the power apps, which creates the PowerBIIntegration object. I can use the value in a page and use notify to display it. As soon as I add Naigate to the OnStart the same Notify (Before the Navigate) is blank.

Re: Power BI

lbendlin — Fri, 20 Dec 2024 14:13:59 GMT

Maybe OnStart is too soon. See if you can use a different event, or a delay.

Re: Power BI

NightSpeedOne — Fri, 20 Dec 2024 20:29:40 GMT

So you got me thinking about delay, while seaching and not finding a delay function I did find timer and it has auto start and onend. So I moved the timer to a splash screen and set it for 1 second and then added the navigate to the onend. Works perfect.

Re: Power BI

Anonymous — Mon, 23 Dec 2024 06:09:51 GMT

Hi,@NightSpeedOne
We are absolutely delighted to hear that the issue has been resolved. If you’re inclined, you might consider accepting this solution, as it could also assist other community members facing the same problem, enabling them to find a resolution more swiftly.

Of course, if there is anything else we can do for you, please do not hesitate to contact us.

Looking forward to your reply.

Best Regards,

Leroy Lu