Forum Discussion
Analyze - Explain the increase
v-chuncz-msft - Thanks for your reply. I found a fix and a similar related post from JSummergill, that was essentially my issue.
JSummersgill Hi, I just read your post as I'm encountering the exact same issue. I appear to have resolved it now, after breaking my report apart in stages.
My Fact tables are linked to CRM tables also (Dynamics 365), and it appears the Row Level Security was cusing me problems in the PBI service. I've since removed them and the Analyze function comes back in Service.
I'm about to start research now on how to introduce RLS without causing this issue, unless it has trouble when linking to Dynamics.
Anyways, in case this helps anyone else with this issue, it solved my problem as a short term fix.
Regards
Ben
Community SupportAnonymous
It works fine for me. You may take a good look at Use insights to explain increases and decreases.
v-chuncz-msft - Thanks for your reply. I found a fix and a similar related post from JSummergill, that was essentially my issue.
JSummersgill Hi, I just read your post as I'm encountering the exact same issue. I appear to have resolved it now, after breaking my report apart in stages.
My Fact tables are linked to CRM tables also (Dynamics 365), and it appears the Row Level Security was cusing me problems in the PBI service. I've since removed them and the Analyze function comes back in Service.
I'm about to start research now on how to introduce RLS without causing this issue, unless it has trouble when linking to Dynamics.
Anyways, in case this helps anyone else with this issue, it solved my problem as a short term fix.
Regards
Ben