Using Direct Query vs Import with Power BI

…We will call the reports DQ: Now log into PowerBI.com. You will see “the data source is missing credentials and cannot be accessed”: We need to set up Refresh. Click…

Convert FetchXML to QueryExpression in Dynamics 365 with Web API Example

…name. E.g. https://yourorg.api.crm.dynamics.com/api/data/v9.1/accounts?$select=name,revenue&$filter=name eq ‘3M’ In Visual Studio, create a new Class Library: Click Next Add NuGet packages: Use the following code. We will use FetchXmlToQueryExpressionRequest and FetchXmlToQueryExpressionResponse to convert…

Accessing Advanced Customizations in PowerApps

…in PowerApps, log into https://powerapps.microsoft.com: and select Settings -> Advanced Customizations: This will open the Advanced Customizations pane: From here, we can manage Users, Security Roles, Themes, Publishers and Developer…

Using, Loading and Creating Report Themes in Power BI

…Classroom: Colorblind Safe: Electric: High Contrast: Sunset: Twilight: Themes are available from the Theme Gallery, located at https://community.powerbi.com/t5/Themes-Gallery/bd-p/ThemesGallery: To install a theme, select it: Then find the JSON file and…

Connecting Power BI to a Website to Import Data

…Power BI Desktop and select Get Data->Web: Enter a website URL. For example, I have a page that contains a table of Orders sample data. This is located at https://carldesouza.com/sample-date-orders-table-2019/:…

URL Shortcut to your Dynamics 365 Apps

To get to your Dynamics 365 Apps, from your web browser enter the URL of your Dynamics 365 org and add /apps to the URL. For example: https://yourorg.crm.dynamics.com/apps  …

XrmToolBox Metadata Browser

…and remove these columns by selecting Columns. Selecting an entity will display it’s details: And attributes: As well as: Keys Relationships Privileges The source code is located at: https://github.com/MscrmTools/MsCrmTools.MetadataBrowser  …

Running an R Visualization from the Marketplace in Power BI

…an R Visualization from the Power BI marketplace. In Power BI Desktop, under Visualizations select Import from Marketplace: Note you can see these visualizations from AppSource at https://appsource.microsoft.com/en-US/marketplace/apps?page=1&product=power-bi-visuals: Let’s install…

How to Create an Azure Machine Learning Workspace

In this post, we will look at how to create an Azure Machine Learning workspace. First, sign into https://portal.azure.com/ and search for and select Machine Learning: Click Add: Give the…