Day 18 - How to build a POWER BI REPORT from a flat file which is uploaded at Microsoft Teams


Now a days we have started using Microsoft Teams heavily during COVID-19 lock-down period. Usage of MS-Teams is not only limited to Meeting/Call. Now expectation of end-user is  to use flat files which are uploaded at MS-Teams to build a POWER BI Report and also make sure that changes at flat files are getting reflected in POWER BI REPORT

It's a valid request. Isn't it ??



Please follow step-by-step instructions below to create a POWER BI REPORT from a flat file which is uploaded at Microsoft Teams. Hope this helps !!!
  
Problem Statement : How to build a POWER BI REPORT from a flat file which is uploaded at Microsoft Teams

Step 1: Open Microsoft Teams and go to Files tab

Step 2: Select the file and Copy the link  à https://sites.xxyyzz.com/sites/POWERBITipsTricks/Shared%20Documents/General/state_wise.csv



Step 3: Launch Power BI Desktop and navigate to Get Data > Web > Enter “https://sites.xxyyzz.com/sites/POWERBITipsTricks/Shared%20Documents/General/state_wise.csv”



Click Ok and authenticate it at Organization Account level





Step 4: Tada 🎉🎉 You are able to load data in POWER BI successfully!!!

 


Click Load. Now you can go ahead and create a visual of your choice 😊



Step 5: Publish it and search for the data-set at POWER BI Server



 Step 6: Click on highlighted icon to schedule it. A new window will pop up where you have to enter credential to access the data-set while scheduling the daily refresh job.


 Step 7: Click on 'Edit Credentials' and enter details as shown below.




 Step 8: Schedule Refresh section would get enabled ,once you 'Sign in' successfully. 
Please enter scheduling details accordingly to schedule the job !!!   



Enter requested details and click on Apply button. 

Bingo 

😜😜😜

 You have created a POWER BI REPORT successfully from a flat file which is uploaded at Microsoft Teams and also scheduled the report accordingly. 

#RR #Day18 #PowerBI #MS-TEAMS #TEAMS #FlatFiles #ScheduleRefresh #HappyLearning #WeLearnEveryday

Comments

Post a Comment

Popular posts from this blog

Day 32 - Python Script to track Available COVID-19 Vaccine Slots for 18+ in India

Image
 Booking a COVID-19 vaccination slot reminds me of good old days of booking a TATKAL ticket in   Indian train. If you are lucky and very fast with Keyboard then we would be able to book the train   ticket  under TATKAL quota. Otherwise Surprise !!!  Same rule applies here too but we don't have idea about the next available slot timings for vaccination. When is the next slot going to open ? Still it's a suspense for us. By the time we come to know that there are few slots available, CoWIN portal ( https://www.cowin.gov.in/home ) shows that it's already booked. I have observed that people are struggling to find an available slots in their locality. So I thought of writing a python script using public API to track the available COVID-19 vaccine slots in the entire city. Task for interested folks who want to send an alert to a group/channel: Please trigger an email or message on WhatsApp/Telegram group whenever you get any data in the output file - "18plus...
Read more

DAY 13 - Import data dynamically from Oracle DB using Python script in Power BI Desktop

Image
DAY 13 - Import data dynamically from Oracle DB using Python script in Power BI Desktop Step 1 : Python IDLE  & Power BI need to be installed in your system Step 2: Execute the below script independetly in Python IDLE and make sure it's getting executed successfully. import cx_Oracle import pandas as pd connection = None try:     #Oracle DB Connection Details       username = 'p_user_name'     password = 'p_password'     dsn = 'hostname:port_number/service_name'       connection = cx_Oracle.connect(         username,         password,         dsn)       # show the version of the Oracle Database     #print(connection.version)       cur = connection.cursor()     cur.execute("select * from oe_order_headers_all where rownum <=10") #fetching 10 records from Order Header Table ...
Read more

DAY 31 - Organize a Secret Santa Game in your organization using a Python Script

Image
 The script will  perform below mentioned activities: 1.      Assign a Secret Santa randomly to each participant 2.      Save the final extract into an excel file 3.      Send an automated mail to each Secret Santa with a complete address details of his/her Secret Santa Child   Sample final extract file: Sample Mail Format: Prerequisite: 1.       Collect information of participants in an excel file as shown below. 2.  Click on “Manage your Google Account” > Security > Less secure app access Turn ON access for less secure app Note - This setup is required to send a mail from Gmail using Python script   Python Script: # -*- coding: utf-8 -*- """ Created on Wed Dec 2 12:15:58 2020 @author: Rakesh.Ranjan """ import random import pandas as pd import numpy as np import os import string  ss_keys = [] ssc_values = [] input_file_name = "Secret Santa - Information needed-Tes...
Read more