Posts

Showing posts from April, 2021

Create Power BI report from text data source

Image
Step 1: Open Power BI desktop application Step 2: Click on Get data under home tab and select text data source as shown in bellow Step 3: Select text file from local system Step 4: Click on Load icon Step 5: All fields are appearing in fields section as shown in bellow Step 7: Drag and drop table from visualization tab to design panel Step 8: Select required fields from data set as shown in bellow  

Create Power BI report from excel data source

Image
Step 1: Open Power BI desktop application Step 2: Click on Get data under home tab and select excel data source as shown in bellow Step 3: Select excel file from local system Click on check box as shown in bellow Step 4: Click on Load icon Step 5: All fields are appearing in fields section as shown in bellow Step 6: Click on three dots (...) and rename the sheet name Step 7: Drag and drop table from visualization tab to design panel Step 8: Select required fields from data set as shown in bellow

How to create workspace in Power BI

Image
Step 1: Login app.powerbi.com Step 2: Follow bellow screenshots Click on create a workspace Step 3: Create workspace page looks like bellow Provide workspace name and upload image if applicable Step 4: New workspace showing in workspaces list as shown in bellow

Microsoft Business Application Summit (MBAS) on May 4

Image
      Register  

Power BI April 2021 Feature Summary

Here is the full list of April updates:   Reporting •    Power Automate for Power BI   •    Small multiples: padding controls and combo chart support   •    New and improved shapes •    Invert axis and continuous axis sorting   Modeling •    DirectQuery for Power BI datasets and Azure Analysis Services   •    CROSSFILTER supports many-to-many relationships •    Performance improvements to IF and SWITCH functions   Data connectivity •    New Connector: Bloomberg Data and Analytics •    New Connector: SoftOne BI •    Text/CSV By Example now generally available •    Automatic Table Detection from Excel files now generally available •    Automatic Table Detection from JSON files now generally available Service •    Easy report sharing via links •    Impro...

Send SQL Results to MS Teams Using Python

Image
Step 1: Open teams and go to create new team page Step 2: Click on Join or Create a team Step 3: Click on create a team and select build a team from scratch Step 4: Select kind of team Step 5: Provide team name as shown in bellow Click on create Step 6: Add member if required Step 7: Click on 3 dots (...) and select connectors as shown in bellow Step 8: Select Incoming Webhook and configured as shown in bellow Setup incoming webhook name as shown and click on create Copy webhook url and put into mentioned python script Step 9: Python script import pymsteams import pandas as pd import numpy as np import pyodbc server = 'ServerName' database = 'msdb' username = 'LoginName' password = 'Password' cnxn = pyodbc.connect( 'DRIVER={ODBC Driver 17 for SQL Server};SERVER=' +server+ ';DATABASE=' +database+ ';UID=' +username+ ';PWD=' + password) cursor = cnxn.cursor() query = "select top 10 [name],[type_desc],create_date from msd...

Power BI Summit April 19-23, 2021

Description Power BI Summit is a multi-day event bringing speakers from the Microsoft Power BI team’s product group and community experts and MVPs from all around the world. This conference is run virtually, and you can attend from anywhere, all you need is an internet connection and a computer. All Power BI topics will be covered in this conference, from beginner to advance. We will have Power Query, DAX, Dataflow, Visualization, Power BI Desktop, Power BI report server, Mobile experience, Embedded, Power BI Premium, Architecture, governance. There will also be many discussion table talks. This conference would be an opportunity to learn and network online.   Fee : $98.00   Registration: power-bi-summit  

Create power BI report from text file

Image
Step 1: Go to Home tab Step 2: Click on get data and select text or CSV Step 3: Select text file from local Step 4: Click on Load to load data into data-set Step 5: Drag and drop table from visualization panel and select required fields from fields tab  

Check Power BI desktop version

Image
Step 1: Click on Help tab Step 2: Click on about and check version as shown in bellow

How to clear report cache in Power BI

Image
 Step 1: Click on file menu  Click on options and settings Step 2: Click on options tab Click on clear cache under data cache management and Q&A cache options