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.
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.
Improvedย multi-value parameters support for DAXย
When building DAX queriesย for a report with multi-value parameterย from a Power BI dataset,ย users oftenย would run into issues if they had too many parameter values and bump up against the maximum length of a query.ย ย ย
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โฏ.ย