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,
