Latest Posts
How to Power BI Drill through using to selected value column name Showing in Detail Page Title!
In this blog we see about how to drill through the selected visual column showing in detail page title using DAX in this report I have put Button and enable the action drill through. If we select any of visual choose drill though in detail page title shows the selected column visual. Step 1: Enable…
Powerbi Reports integrate with Jupyter Notebook using Python
Prerequisite: Python Latest Version Power BI Service Jupyter Notebok or Visual Studio (Jupyter Notebook Installed) Following Steps: Open Command Prompt install the this package pip install powerbiclient Once install this package open jupyter notebook Or Jupyter notebook installed Visual Studio. am using visual studio. Step 1: Import the Report and Models class from powerbiclient Package.…
How to Create Power BI Paginated Report using Power BI Dataset
In this post will explain to connect Power BI Service Dataset and will see how to build a report using Power BI Report Builder (former SSRS). Need some prerequisite develop report. Prerequisite: 1. Power BI Report Builder 2. Power BI Premium per user(PPU) Or Power BI Premium 3. Power BI Desktop (Optional) 4.DAX Studio (Optional)…
How to connect sharepoint file to Power BI
Step 1: login sharepoint and choose the file for excel or csv like. then select the file and open desktop App. it will opened excel file in your desktop after go to file select the info and choose the copy path. Step 2: Open Power BI Desktop 1.Select Get Data choose to Web paste to…
PowerApps Simple Form Create using Sharepoint
login into Office 365 https://www.office.com/ Select the Sharepoint application and then create a Site. I have Created Private Site in Sharepoint as given in below fig. Then Create to the New List you’re created Group. I have Added columns with below given Fields and Types Employee Name (Single Line Text) Department (Drop_Down) DOB(Date) City (Single…
Create Signature App in PowerApps
Open PowerApps in your Browser https://make.powerapps.comand sign in your account the create Canvas app from blank see below image then click create button. click insert in the top ribbon then select the label see the below image I had change Text name to Signature App and adjust the font size and colors in the label.inside…
How to Handle Multiple Dates column in PowerBI Reports
today we see about how to handle two date column in this blog. i am took the Contoso Dataset. I have Two Tables 1.DIMPromotion 2.DIM Date DimPromotion table have two date column one is StartDate and EndDate DIM Date table have one Date only see below image if we Add two the relationship it will…
Different Between Drill through and Cross Report Drill through in Power BI
Drill through: Drill through simple explain – One page to another page in the specific fields or entity. ReportName- Report1 i was created one report using barchart(clustred column chart) Dimesion is Brand and Measure is SalesAmount. then go to second page and add the Dimesion(BrandName) of 1st page respect visual like then go to the…
Microsoft Power Platform
Powerplatform Make easy to business. 1.#PowerBI has Lot of Services and different custom visuals ,data analytics , collect combine and transform to clean data ,Q&A and etc.. 2.#PowerApps has Build Own Business Apps without code. Knowledge and etc.. 3.#PowerAutomate (Microsoft Flow) has Automate your business Flows & Trigger etc.. Now introduced Part of #PowerPlatform in…
Parameter Using to Connect Two DataSources in Power BI
Thank you to Guy in a Cube – (Patrick ) Open Power BI Desktop from Get Data to select SQL Server Database select the ABC then choose the New Parameter in that. created Server1 and Server2 in the Parameter two Sql Server Instance . see the below images. create same as two Parameter Database1 and…
Use Report Themes in Power BI Desktop
Report themes apply to after design changes in Power BI Desktop. Check below link: https://docs.microsoft.com/en-us/power-bi/desktop-report-themes
Follow Me
Get new content delivered directly to your inbox.
Muthusamy Pandurangan 