Forum Discussion
Conditional Page Navigation with Live Connection
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
4 Replies
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
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
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,
KellyDid I answer your question? Mark my reply as a solution!
