topic Re: Error Fetching Data for this Visual in DAX Commands and Tips

Error Fetching Data for this Visual

ms4112 — Thu, 24 Oct 2024 14:25:57 GMT

Keep getting 'error fetching data for this visual when creating a matrix table.

but only when i select these two measures i created:

this is the dax i created:

could anyone help resolve - first time user

Re: Error Fetching Data for this Visual

FreemanZ — Thu, 24 Oct 2024 20:16:41 GMT

hi ms4112 ,

try like:

change % =

VAR _2021 =

VAR _2022 =

RETURN DIVIDE(_2022, _2021) - 1

we can't reference a measure in its own definition.

Re: Error Fetching Data for this Visual

lbendlin — Thu, 24 Oct 2024 20:45:51 GMT

What happens when you click on the "See details" link?

Re: Error Fetching Data for this Visual

ms4112 — Fri, 25 Oct 2024 10:52:17 GMT

'unexpcted exception occured' - not v helpful haha

Re: Error Fetching Data for this Visual

ms4112 — Fri, 25 Oct 2024 10:54:49 GMT

so this is actually a reference to my second measure which is revenue chnage YoY in £

then i did rev change yoy in %

see below:

so ive followed the same formula as solutions, do you think it could be a setting that needs changing i only downloaded/started using PBI yday for an assignment

Re: Error Fetching Data for this Visual

Anonymous — Wed, 30 Oct 2024 06:59:37 GMT

Hi ms4112 ,

The photos you uploaded are broken.
Please upload them again so that we can better understand the problem and help you.

Best Regards,
Dengliang Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Error Fetching Data for this Visual

fclh — Fri, 01 Nov 2024 11:09:31 GMT

After updating the 32-bit version (10/2024), I got this message for several kind of visuals, in all the deskop reports.

In PBI service, in Teams the visuals were okay.

Possible solutions for the desktop version didn't help. Had to re-install an older version (09/2024) and it works perfect again.