Uncategorized Archives | Cloudfronts - Microsoft Dynamics 365 | Power BI | Azure

Category Archives: Uncategorized

Making SQL Server Accessible Over Internet

We can Make the SQL Server Accessible over Internet by following steps: 1. System should have static IP where SQL server is installed. 2. Open SSMS, right click on server > properties and check SQL Server and Windows Authentication mode 3. Go to Server > Security > Logins and configure password for users, who will be accessing the … Continue reading Making SQL Server Accessible Over Internet

Share Story :

How to Create Storage Account in Azure Portal

Hi, in this blog we will see how to create a storage account in azure portal. On the Azure portal menu, select All services. In the list of resources, type Storage Accounts. As you begin typing, the list filters based on your input. Select Storage Accounts. On the Storage Accounts window that appears, choose Add. Select the subscription in which to … Continue reading How to Create Storage Account in Azure Portal

Share Story :

Conditional Formatting by Row in a Matrix

Introduction: This blog will show you how you can color individual rows differently based on different conditions and the row headers in matrix (Not alternating rows). Our Scenario: I want to apply colors to different rows of the following Buckets: Current – No Color 1-30 Days Past Due – Yellow 31-60 Days Past Due – … Continue reading Conditional Formatting by Row in a Matrix

Share Story :

Trigger Power Automate on Condition

Introduction This blog explains how we can trigger Power Automate based on the required condition. Suppose you have a requirement where you want your flow should get trigger based on some condition then you can check condition on “Trigger” itself rather than adding a new action to check condition. Use Case: Trigger flow when Lead … Continue reading Trigger Power Automate on Condition

Share Story :

Accessing SharePoint Recycle Bin using Microsoft Flows

Introduction: This blog provides steps to follow in order to access the SharePoint Recycle Bin in MS Flows   Steps: 1) In Actions, select “Send an HTTP request to SharePoint” 2) Enter the below details: Site Address: Select your site address from the list. Method: GET Uri:_api/web/recycleBin?$filter=DeletedDate eq datetime’Time Deleted’ and DeletedByName eq ‘Deleted by’ … Continue reading Accessing SharePoint Recycle Bin using Microsoft Flows

Share Story :

SSRS Reporting Date Formats from CRM Online

Key Technologies:  SQL Server Reporting Services, CRM Online Create a report in SSRS. Configure data source and credentials. Query the dataset and map the fields on the table. Date format on the report needs to be displayed as it is in CRM (“dd/MM/yyyy“). But the problem is when we use fetchXML to retrieve the data, datetime … Continue reading SSRS Reporting Date Formats from CRM Online

Share Story :

How to publish Power BI report to website without authentication

Hello everyone, in this blog we will see how to publish Power BI report to website without authentication. If you want to display a report in your website and that should be visible to non Power BI users as well then you have to do it in following way. Step 1: Create a Power BI … Continue reading How to publish Power BI report to website without authentication

Share Story :

Adding Data Source to Tabular Model

In this blog we will see how we can add data source(SQL Server) to tabular model Pre-requisite: SQL Server with AdventureWorksDW2017 database Go to Tabular Model Explorer > Data Source and Click on Data source and select Import from data sourceand it will prompt to select data source, in this case we will select SQL … Continue reading Adding Data Source to Tabular Model

Share Story :

Creating Document Map in SSRS

Document Map makes navigation is easy to navigate through table in SSRS In our case we have dataset which contains Product and Product Subcategory. We created the 2 parent groups on Product key and Product Subcategory key. We have to go in the Parent group(ProductCategoryKey) >Advanced > Document Map and select the column used for … Continue reading Creating Document Map in SSRS

Share Story :

SEARCH :

FOLLOW CLOUDFRONTS BLOG :

Agro-Tech Services Success Stories

Please fill your details to download the file.

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close