Introduction: In this article, we will learn how to configure Power BI Gateway. Steps to configure Gateway Login to Power BI service. Select Downloads icon> Data Gateway. You will be redirected to Power BI Gateway Download Page and click Download Gateway. Run the PowerBIGatewayInstaller. Click Next and then Install. The Power BI Gateway will be Installed. … Continue reading Steps to configure Power BI Gateway →

Introduction: Recently, we encountered a strange behavior of Scribe On-Premise Agent when we deployed a DLLs for a Custom Connector. After deployment of DLLs on the Agent, the status of the Scribe Agent was stuck at “Updating” and the Connector was not visible under the connector drop down. Troubleshooting: We checked the “MICROAGE1 Agent 2” Agent … Continue reading DLL Deployment Error on Scribe On-Premise Agent Server →

With Excel 2016, you can publish your Excel workbooks right to your Power BI site, where you can create highly interactive reports and dashboards based on your workbook’s data. You can then share your insights with others in your organization. Requirements: 1. Before publishing to Power BI, workbook must be saved to OneDrive for Business. 2. Only … Continue reading Publish Workbook to Power BI from Excel File →

Yes, you heard it right, you can import Microsoft Excel Workbook to Power BI and show you selected section in you powered dashboards, let’s see how it works, as Microsoft Excel is one of the most widely used business applications around. It’s also one of the most common ways to get your data into Power … Continue reading Import Excel Workbooks in Power BI Dashboards →

Introductions: This blog highlights the feature for Drillthrough in Power BI Services, this is the ability to define a report page as a drillthrough page. You can now define an individual report page as a Drillthrough page. Ideally these report pages should be configured across a single entity. With that focused report page, users can … Continue reading Drillthrough Reports in Power BI →

Introduction: You can import XML as a data source, using Scribe Insight, to execute two primary actions: Integrate with locally available XML data. Receive data as XML from remote systems. Steps: Open Scribe Workbench and click on ‘Configure Source’. Click on ‘New’ and select XML. The XML Component Connection Wizard will open. Click Next. Select … Continue reading To Configure XML As Source In Scribe Insight →

Introduction: Power BI comes with a powerful language recognition engine that lets you ask questions of your data using conversational phrases and questions. Based on these questions, Power BI dynamically creates charts and graphs. For example, if the data is defined as a date type, it is more likely to be displayed as a line … Continue reading Natural Language Q&A in Power BI →

Introduction: In this Blog article, we explain about the new feature of the power BI: Bookmarking. Bookmarking: Bookmarking is the a very powerful way to save and share out your Reports and Dashboards with other people. Bookmarking lets you save your interesting states as part of your report. You can create list of bookmarks. Using … Continue reading Power BI new Feature: Bookmarking →

With Scribe Insight, you can import XML as a data source to fulfill two main tasks: Support integration with locally available XML data. Receive data as XML from remote systems. Creating A Publisher Expand the Console site node. Expand the Integration Server node, and then click Publishers and Bridges. The Publishers/Bridges window opens. Click ‘Add’. The ‘Add New Publisher/Bridge’window opens. Add … Continue reading Retrieving the XML Schema and XML file for a record in Scribe Insight →

New SQL Server Management Studio 17.3 Release update: This wizard was created to improve the current import experience leveraging an intelligent framework known as Program Synthesis using Examples (PROSE). For a user without specialized domain knowledge, importing data can often be a complex, error prone, and tedious task. This wizard streamlines the import process as … Continue reading Import Flat File to SQL Wizard →