cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

error refreshing from live database

I made a dashboard using data from a SQL database.

 

I set up the dashboard so that it functions perfectly well. No errors in any calculations, etc.

 

When I refersh my ldata, my entire dashboard is in a mess. Errors show up where there were no errors previously. All my DAX generated tables fail due to errors. 

 

Works prior to refreshing:

 

Recent Scores = SUMMARIZE('Recent Score','Recent Score'[LOCALE],"% Of 3's",ROUND(100*COUNTROWS(filter('Recent Score','Recent Score'[Score]=3))/COUNT('Recent Score'[LOCALE]),1))

 

- "An argument of function 'ROUND' has the wrong data type or the result is too large or too small." - this occurs to 10 DAX tables when which aggregate the main table

 

The odd thing, is previously it worked with no problems.

 

Any suggestions are very welcome

 

 

 

 

2 REPLIES 2
Community Support Team
Community Support Team

Re: error refreshing from live database

HI, @Anonymous

Try to make it like this ROUND(IFERROR(...,0))

Recent Scores =
SUMMARIZE (
    'Recent Score',
    'Recent Score'[LOCALE],
    "% Of 3's", ROUND (
        IFERROR (
            100
                * COUNTROWS ( FILTER ( 'Recent Score', 'Recent Score'[Score] = 3 ) )
                / COUNT ( 'Recent Score'[LOCALE] ),
            0
        ),
        1
    )
)

 

Best Regards,

Lin

 

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

Re: error refreshing from live database

hi, @Anonymous

Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?

 

Best Regards,

Lin

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

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 40 members 1,130 guests
Please welcome our newest community members: