Conditional Page Navigation with Live Connection

[jcichansky18]

Hi guys,

I have MSSQL table with same values. I also have PBI report, where page names are the same as values in my table. Now I want to do conditional page navigation. If I use SQL Server - Import mode, then everything works fine. But when I use Analysis Services - Live connection, then Field (Action - Page Navigation - Conditional based on Field Value) is greyed out and I can't use this feature. Don't you have an idea why?

Thanks

[amitchandak]

@jcichansky18 , Live connection have few limitation, like new column, modification of data type etc.

Refer

https://radacad.com/directquery-live-connection-or-import-data-tough-decision

[jcichansky18]

Yes, I'm aware of all limitations related to Live connection, but I didn't see any limitatations with Conditional page navigation in Microsoft documentation

[rsbin]

@jcichansky18,

Did you find a solution to this issue?  I am encountering the same thing just now, yet in numerous other models my "GO" button works just fine.

Appreciate any feedback you might have.

[v-kelly-msft]

Hi @jcichansky18 ,

As tested here,page navigation works fine with live connection:

Would you pls open a new pbix , reconnect it with live connection mode and check again?

Best Regards,
Kelly

Did I answer your question? Mark my reply as a solution!