Power BI Filter not working when embedded into D365

[khampton]

I have a Power BI report which is embedded into D365 and initially the filter was requested at Account level which works fine.

I was later ased to change this to ccompanyID, so using a companyID field which is a bespoke field in D365 Accounts.

If the Company ID is null, the filter appears and filters on (blank) which is expected:

However when the field is populated I'm getting the error:

"This field was deleted from the model and can't be used as a filter"

Hovering over both filters gives the same table and field name, so any ideas why this may be?

I'm completely new to D365 and embedding PowerBI reports!

[khampton · Accepted solution]

Fo anyone struggling with this issue, the issue seems to be where there is a mix of values and strings.

Changing the format to string for all cases doesn't work, but adding letters to the value figures so they become strings did work, so there you go.

Haven't yet tested using numerical only fields though, that'll be next up.

[pavanmanideep]

@khampton Glad you found the solution.

Cheers,

PMDY

Blog:https://ecellorscrm.com

[pavanmanideep]

Hi @khampton ,

Can you check if you were not facing any issue in Power BI Desktop?

Cheers,

PMDY

[khampton]

I can confirm the filter works perfectly in desktop!

[pavanmanideep]

Hi,

Can you confirm if you don't have any special characters in your fields which were being used for the filters. It is because, when id is blank, it is getting filtered out, hence you dont face any issue.

If I have answered your question, please mark your post as Solved.

If you like my response or got a direction forward to proceed, please give it a Thumbs Up. Appreciate your Kudos. You can accept more than one post as a solution.

Blog:https://ecellorscrm.com

Cheers,

PMDY

[khampton]

There are numbers and letters but also spaces and the data is stored as an nvarchar.

I've tried converting to varchar and this hasn't worked.

[pavanmanideep]

Hi,

I see there were two companyid filters, possibly both could be from different tables, where one was deleted from the dataset. The filters set dont automatically refresh once the field is deleted, make sure all the fields used as filters should be present in your dataset.

Hope this helps...

If I have answered your question, please mark your post as Solved.

If you like my response or got a direction forward to proceed, please give it a Thumbs Up. Appreciate your Kudos. You can accept more than one post as a solution.

Blog:https://ecellorscrm.com

Cheers,

PMDY

[khampton]

Hi,

Thanks for your response, but it doesn't solve my issue. The filter is duplicated I assume because one is from the Power BI report itself and the other is the one added by Dynamics 365. Both filters show Table1[companyid] when hovered over, so they should be working on the same table and field. Deleting the filter from the Power BI report so only one filter appears in the embedded report still gives the deleted field error. The field is apparently not deleted when the companyid field is blank so the issue only occurs when I'm on the account page of an account with a populated company id.

It also works fine when using Account name as the filter field, I still get duplicated filters, but the reports are filtered to the appropriate account.