Anonymous's avatar
Anonymous
Not applicable
7 years ago
Status:
Needs Info

Power Bi update Power BI Desktop refresh error

Hi,   I have been facing a problem with data refreshes which started after PBI desktop was updated to the September version. I have a Pbix file that connects to an Excel file located in a Sharepoin...
Reports
mda's avatar
mda
Advocate I
7 years ago

I have an identical error, but not on refresh but after open report developed in the previous version of Desktop.

The error is reported for Clustered column chart, but when I switch it to other chart type keeps showing.

 

After first open, and again after changing chart to the Stacked column chart SQLDUMP.exe program is opened in command line window, and is closed after a while.
The problem is present for any visualization even for the table.

 

The problem disappears when I remove Ranking measure.

This measure is defined as:

Ranking =
IF (
    ISBLANK ( [Measure Value] );
    BLANK ();
    RANKX (
        FILTER ( ALLSELECTED ( Dimension[Level] ); NOT ( ISBLANK ( [Measure Value] ) ) );
        [Measure Value];
        ;
        DESC;
        SKIP
    )
)

 

Completed Ideas