python (65.2k questions)

javascript (44.3k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (13k questions)

Questions - powerbi-paginated-reports

Power BI Paginated Report stopped working

This week, a Power BI paginated report that was working, stopped working and is throwing the below error: There was an error communicating with Analysis Services. Please verify that the data source is...
test-img

SamBouKoa

reporting-services

powerbi

powerbi-paginated-reports

Votes: 0

Answers: 1

Latest Answer

The issue with using RSCustomDaxFilter function is that it currently will not work in daxstudio.
test-img

Gary Thomann

SSRS number of occurences for runningvalue

I'm trying to create the ABC / Pareto Analysis. Intention is to mark by 'A' all products which generate 80% of total sales, 'B' products which generate additional 15% and 'C' the rest. It's up to 100k...
test-img

Emp24

reporting-services

powerbi

ssrs-tablix

reportbuilder

powerbi-paginated-reports

Votes: 0

Answers: 1

Latest Answer

You can use custom code for your pareto count calculation. Add the following code to your report Public Dim a_count, b_count, c_count As Integer Public Function Pareto( current As Integer, total As ...
test-img

niktrs

PowerBI Paginated Reports and SSAS, can we avoid datasets?

We have a user friendly frontend providing PowerBI Embedded combined with a tabular cube coming from analysis services to enable superfast interaction with the data. This works flawlessly. PowerBI Emb...
test-img

Micha Schopman

powerbi

ssas

ssas-tabular

powerbi-paginated-reports

Votes: 0

Answers: 1

Latest Answer

In a paginated report a "dataset" is simply the result of a query that's available for binding to visuals in your report. It's a completely different concept from a Power BI "Data Set&...
test-img

David Browne - Microsoft

How to create zero-count rows in recordset in Power Query / Power BI when summarizing data

I'm trying to use Power BI, with Power Query, to summarize some data for an SSRS/Paginated Report. What I want to display to the user in the report, is a table with counts of list items. Columns will ...
test-img

Chloraphil

powerbi

powerquery

powerbi-paginated-reports

Votes: 0

Answers: 1

Latest Answer

Ah. Load a list of offices into PowerQuery and name the query OfficeList with a single column named OfficeList. File close and load, connection only Load a list of Age Groups into PowerQuery and name ...
test-img

horseyride

Posts

Questions

Blogs

Jobs