Finance | Project Operations, Human Resources, ...

Financial Analysis Dashboard error

(0) Share

Report

Posted on by Ramon L

159

I'm getting an error on the workspace while trying to run a dashboard report

I'm trying to simply run the default financial analysis workspace dashboard. has anyone seen this error before or knows where I can find a possible solution for this error. I think it pulls from the Power BI Environment:

I have the same question (0)

All responses (15)

Answers (0)

Sort by

Bala Chandra 355 on at

Like (1)

Report
Copy link

Link copied!

Hi Ramon,

Whether Power BI configured and the default reports deployed?

Thanks,

Bala Chandra

Was this reply helpful? Yes No
Suggested answer

Ajit 8,788 on at

Like (1)

Report
Copy link

Link copied!

Make sure aggregate measure are being refreshed related to this particular dashboard. Search for 'Entity store' (System Admin - Setup - entity store) and refresh

Was this reply helpful? Yes No
Ramon L 159 on at

Like (0)

Report
Copy link

Link copied!

Hi Ajit , i have checked that and refreshed everything, however when I re-run the dashboard still fails to show any data, the error I get:

QuerySystemError

Was this reply helpful? Yes No
Ramon L 159 on at

Like (0)

Report
Copy link

Link copied!

Hi Bala

Everything was running fine last month, now all of a sudden I get the error, and the dashboard fails to show anything at all

QuerySystemError

Was this reply helpful? Yes No
Suggested answer

Ajit 8,788 on at

Like (0)

Report
Copy link

Link copied!

When you click on refresh, batch job(full reset) gets added, make sure that job ran successfully.

Was this reply helpful? Yes No
Suggested answer

Ajit 8,788 on at

Like (0)

Report
Copy link

Link copied!

And if you still see that error, I would check the web.config and see if it has correct details of AXDW database and matching LCS environment details

<add key="BiReporting.DW" value="*********" />

<add key="BiReporting.DWPwd" value="*******" />

<add key="BiReporting.DWRuntimePwd" value="******" />

<add key="BiReporting.DWRuntimeUser" value="******" />

<add key="BiReporting.DWServer" value="********" />

<add key="BiReporting.DWUser" value="axdwadmin" />

Was this reply helpful? Yes No
Ramon L 159 on at

Like (0)

Report
Copy link

Link copied!

Hi Ajit

The Measurement FinancialReportingTransactionDataV2 was deployed and populated successfully.

Was this reply helpful? Yes No
Ramon L 159 on at

Like (0)

Report
Copy link

Link copied!

Ah ok, that's a bit higher grade answer for me, how do I do this task? Do you have the steps for me to complete this

Was this reply helpful? Yes No
Suggested answer

Ajit 8,788 on at

Like (1)

Report
Copy link

Link copied!

Ok Ramon. lets check the web.config. Did you restore the DB recently?

Was this reply helpful? Yes No
Ramon L 159 on at

Like (0)

Report
Copy link

Link copied!

Not at all. MS ran a security update over the weekend on out Prod environment. But we have not done anything other than that

Was this reply helpful? Yes No