Skip to main content

Power BI Paginated Reports August 2020 Updates

We have several exciting updates rolling out this month for paginated reports! These updates include new authentication type support for Azure SQL DB and Azure Synapse, Common Data Service data source support,  improved multi-value parameters support for DAX and more!  Check out the full blog to learn more about all the updates and enhancements.

Download Power BI Report Builder


New authentication type support for Azure SQL DB and Azure Synapse 

We have added the option to connect to both Azure SQL Database and Azure Synapse using Azure AD Multi-Factor Authentication to match the authentication support we have in the Power BI service.

New authentication window for connecting to Azure SQL database and Azure Synapse.

Common Data Service data source support

For the first time, we now offer direct connectivity to the Common Data Service with paginated reports through the SQL data connection.  With this support comes the ability to use the native relational query designer for SQL in the product.  This allows you to create your queries against CDS just like you would when using any SQL data source.

Relational Query Designer

Improved multi-value parameters support for DAX 

When building DAX queries for a report with multi-value parameter from a Power BI datasetusers often would run into issues if they had too many parameter values and bump up against the maximum length of a query.   

RSCustomDaxFilter expands each value before the DAX query is executed

With this release, we’ve changed how we handle this in product and most users should no longer see this error when using Power BI Datasets or Azure Analysis Services as their data source.

Improved parameter dropdowns in Power BI

We have addressed couple of usability issues related to parameter dropdowns. Now the dropdown options are auto expanded to fit the largest item so you can read the entire value and not have to rely solely on the tooltip. We also open the dropdown to selected value by default, so you don’t have to scroll through a long list of values to get to the selected item.

We hope you’re as excited about these changes as we are.  Be sure to leave your feedback in the comments below, and feel free to submit your feature ideas.