Power BI embedded error

(0) Share

Report

Posted on by Tony zhong

903

Hello everyone,

When creating a Power BI report on my system and then embed it, facing error "SystemQueryError" like this :

Anyone here can advice me where or how to investigate this ? FYI, I already refresh my Entity Store which solely use by this report and fully populated. As this is still in UAT, I can also test the report by upload it to my PowerBI.com workspace and it is working just fine, it is connect to same server, same DB, and same aggregate measures, but in F&O workspace, some of the visual failed to display like below:

As we can see, some card and chart are displayed correctly, as well as the slicers which getting from the same Aggregate measures from AX. All of this data coming from 1 Aggregate measures which confuse me what is the issue here ? Why only some failed some are not.

I only know there is a problem with Power BI version, but I already cater that, I'm using the older version which is still supported by F&O at the moment.

The error it self doesn't give me much information.

Any advice is highly appreciated.

Thanks,

I have the same question (0)

All responses (3)

Answers (0)

Sort by

WillWU 22,363 on at

Like (0)

Report
Copy link

Link copied!

Hi Tony,

Please try to enable the "Full reset" batch job.

You could switch the “Automatic refresh enabled" to Yes in Entity store, it will schedule a new “Full reset” batch job.

rahulmsdax.blogspot.com/.../couldnt-retrieve-data-for-this.html

Was this reply helpful? Yes No
Tony zhong 903 on at

Like (1)

Report
Copy link

Link copied!

Hi Will,

I did refresh the entity store. As mentioned, it is fully populated.

And I must say, in PowerBI.com it is fine.

Thanks,

Was this reply helpful? Yes No
Tony zhong 903 on at

Like (0)

Report
Copy link

Link copied!

Hi admin,

this topic / issue has not being solved yet :)

I was meant I did refresh (Full reset) as Will's said already, as mentioned in my first enquiry, however the result is those errors.

Thanks,

Was this reply helpful? Yes No