Latest Microsoft Dynamics 365 Blogs | CloudFronts

Hiding Filter Pane in Power BI Reports

Posted On June 24, 2020 by Shrusti Talati Posted in Tagged in

While viewing reports in Power BI service/ Power BI Desktop, Power BI provides a feature to eliminate the filter pane completely in order to provide a professional look. Here are the ways to Hiding Filter Pane in Power BI reports. 1.Show/Hide the filter pane from report readers. By default, the Filters pane is visible to the end-users. If we don’t want them to see it, we can select the eye icon next to Filters and hide it. 2. Turning on/off the filters from Settings. Steps: Open the Power BI Report in the desired workspace and go to the content section. Select More options (…), then select Settings for that report. Go to the Filtering Experience and disable both the options to hide the filter pane. 3. Showing the desired filters in a user-friendly manner: We can select the filters which we want to display to the end-user depending on the users requirement. Hover-over the filter icon on the right-hand corner to view the read-only filters. Whichever filter we do not want to display to the user, we can hide them in the filter section of the report. Hope this helps!

Share Story :

Register an application entity in Azure Active Directory

Posted On March 5, 2020 by Shrusti Talati Posted in

The following steps are to be followed to register an application entity in Azure Active Directory:- Go to Azure Active Directory and Click on App Registrations. Click on New Registration, Enter a name and the Redirect URL and click Register. Copy and save the Application(client) ID and Tenant ID in a text file. Generate a key for the Client ID from Certificate & secrets section.Go to Certificate & secrets and click + New Client Secret.

Share Story :

How to bring “AI” to Power BI

The February 2019 release of Power BI Desktop unveiled a new, out-of-the-box visual to Power BI called Key Influencers. Key Influencers is Power BI’s first Artificial Intelligence (AI) powered visualization. Microsoft has long incorporated AI capabilities in Power BI through features such as Natural Language (Q&A) and Quick Insights. However, with Key Influencers report developers now have explicit control in leveraging AI to discover insights in their data. Even more, Key Influencers is essentially multiple visuals baked into one! The Key Influencers visual is comprised of two tabs: Key Influencers and Top Segments. The Key Influencers tab will display a ranked list of the individual contributing factors that drive the selected condition. The Top Segments tab will take this a step further and display groupings of key influencers and their impact on the selected condition. The Key Influencers tab runs a LOGISTIC REGRESSION to analyze your data and identify the main factors that influence a specific metric or condition. Scenario: The customers of a company are using a particular cloud service. The Product Manager of that company wants to conduct a survey and analyze factors (Key Influencers) that drive the customers to provide a negative feedback i.e low rating after using the cloud service. KEY INFLUENCERS TAB The Top Influencers are:- Role in Org is consumer The people whose role in the organization is consumer have 2.57 times more chances to provide negative feedback than people whose role is adminstrator or publisher. 2. Theme is usability Second most influencing factor is Theme is usability which means the most negative reviews are provided for Usability. All the Key Influencers tab gives us two panes of visuals. For example, on the left-hand pane you have an infographic of the key influencers themselves, ranked based on their relative impact on the condition being analyzed And the right-hand pane will display a chart containing the values of that attribute, along with the average percentage that value matches the condition. All these factors change continuously depending on the parameters.For example if we add a slicer of company size, the top influencers will change- TOP SEGMENTS TAB On the Top Segments tab, you will see how groupings of key influencers affect the selected condition.  The segments are ranked based on the percentage of records where the condition is met. The size of each segment bubble represents how many records (population count) are in the segment. LIMITATIONS The key influencers visual has some limitations: Direct Query is not supported Live Connection to Azure Analysis Services and SQL Server Analysis Services is not supported Publish to web is not supported .NET Framework 4.6 or higher is required. Hope this is helpful! For more such posts visit- https://www.cloudfronts.com/why-you-should-migrate-from-excel-to-power-bi-for-reporting/

Share Story :

Quick Tips For Formatting SSRS Reports

The tips for formating SSRS reports have been covered here. The Default margin settings have been given as to avoid the blank page issue And give the report a formal look. Also, how to Align Page Number in center of the page has been showed. Default margin settings:- Aligning Page Number in center of the page :- Select Page Number Text Box-> Format->Center in Form Hope this helps! For more such blogs refer the below link. https://www.cloudfronts.com/how-to-use-level-up-for-dynamics-365-crm/

Share Story :

Why you should Migrate from Excel to Power BI for Reporting

Microsoft Excel has traditionally been the go-to reporting tool for businesses, but Power BI offers powerful analytics and reporting features for organizations. With faster experimentation with visualizations, statistical functions and calculations across broad datasets and ability to derive answers on the fly through the rapid recombination of fields, it is clear that Power BI delivers far greater insight than Excel. Reasons Why You Should Migrate Reporting from Excel to Power BI: 1. Storing and Accessing Large amount of Data Power BI has very impressive compression abilities for Microsoft Excel and text/.csv files, which allows you to view, analyze and visualize huge quantities of data that cannot be opened in Excel. Large datasets don’t have to be cut down in size and aggregated to show more encompassing analysis. 2.Applications Excel does have some of the newer charts now, they can’t connect to the data model. But Power BI is ideal for Dashboards, alerts, KPIs, and visualizations, including analyzing your data visually. 3.Reports Excel reports are normal and ordinary comparing Power BI whereas Power BI offers Beautiful branded reports comparing Excel. 4.Cross Filtering Power BI allows advanced features in Cross filtering between charts unlike excel. 5.Dashboard Refreshment You can refresh data in Power BI. Excel does not allow dashboard refreshment. 6.DataSet Power BI has the capability of handling larger dataset. Excel can handle limited dataset only. 7. Incredible Cloud-based Features Once you have finished constructing your Power BI analysis, you need a way to publish and disseminate your dashboards and reports. In Excel this would typically involve emailing a large file around, putting it in a shared drive or SharePoint portal, and letting people know it has been updated.With Power BI offered “publish” this process has been completely revolutionized. 8.Natural Language Query This incredible feature allows users to type questions and get an answer, either in a default or user-specified form. This is useful for executives with specific questions and business users who are unfamiliar with Power BI or the data model behind the report. Power BI is an easy tool to use that helps propel organizations into a data driven culture. With powerful self-service abilities, no longer are business users dependent on IT for gathering, transforming and analyzing data. Automation of dataset integration, ease of expansion into new data sources, rapid visualizations, and easily deployable Row Level Security are amongst the many reasons Power BI is a necessity.Additionally, a cloud-based collaboration environment with features like Natural Language Query ease the process of data governance. In the age of analytics, it’s import for organizations to intelligently utilize the data they collect to rapidly evolve with changing business and consumer habits. For more such blogs refer the below link. https://www.cloudfronts.com/how-to-use-level-up-for-dynamics-365-crm/

Share Story :

How to use “Level up” for Dynamics 365 CRM?

This chrome extension allows to easily find the logical names of entities. It also allows Dynamics CRM users to perform advanced actions, that normally require bookmarklets. Steps: Install Chrome Extension Link-https://chrome.google.com/webstore/detail/level-up-for-dynamics-crm/bjnkkhimoaclnddigpphpgkfgeggokam   The other major functionalities provided are: Hope this helps!

Share Story :

SEARCH BLOGS:

FOLLOW CLOUDFRONTS BLOG :


Secured By miniOrange