Power BI Account Schedule Report to show blank rows between groups

(0) Share

Report

Posted on by Anita75

1,165

Hi All,

Once an account schedule is pulled to power BI using powerbifinance WS only rows with posting or formulas are shown, how do we show empty rows between rows and title rows as below from the schedules so the report looks better:

I have the same question (0)

All responses (7)

Answers (1)

Suggested answer

Steven Renders 5,672 Moderator on at

Like (0)

Report

I don't know how you created the pbi report, but usually when you right click a field, in this case that would be the account name, from a visual there's an option: "show items with no data".

Was this reply helpful? Yes No
Anita75 1,165 on at

Like (0)

Report

Thanks this helpful but the issue is these rows are not shown in the underlying table information - in get data --transform step

Was this reply helpful? Yes No
Verified answer

Steven Renders 5,672 Moderator on at

Like (0)

Report

Then you should verify the data source you are using. Is it a query object or a page? Do they contain the missing data? If not, then you either need to adapt the, so thay include the data, or create new ones that do. Or, during import, find a way to add the data, if possible.

Was this reply helpful? Yes No
Suggested answer

field service sampl... 80 on at

Like (0)

Report

the odata source data entities are controlled by Microsoft. product team. you are stating that the data does not include blanks. there is little to no documentation on these. you should probably request an option to include blanks or a workaround to deal with this in a support ticket. another solution would be to have the entire list and do a left outer join which would include the entire list -- the items with data would be populated and the others would be null or zero.

Was this reply helpful? Yes No
Suggested answer

field service sampl... 80 on at

Like (0)

Report

may have misunderstood you question-- adding blank rows in a report to separate groups-- different issue on format of the report.. you would need to modify the pbi report.

Was this reply helpful? Yes No
field service sampl... 80 on at

Like (0)

Report

ONLINE version (not on-prem) -- if you are using the getdata in powerbi -- the odata source data entities are controlled by Microsoft. product team. you are stating that the data does not include blanks. there is little to no documentation on these. you should probably request an option to include blanks or a workaround to deal with this in a support ticket. another solution would be to have the entire list and do a left outer join which would include the entire list -- the items with data would be populated and the others would be null or zero.

in power query you can transform data from the odata source. and in powerbi report designer develop/format your report.

the blanks lines you want between groups would be done in formatting the power bi report --if that is what you are using.

Was this reply helpful? Yes No
Anita75 1,165 on at

Like (1)

Report

I think since the standard web service does not provide the bank rows we can build a new web service based on the accounts schedule rows - showing all the lines. This way end users can easily maintain report format by modifying account schedules

Was this reply helpful? Yes No