top of page
Typ
Kategorie
110 Ergebnisse gefunden für „“
- Power Bi interview 3.5 years experience.In Tech Talk·July 22, 2023Interviewer Hi, Shivika. candidate Hello. Interviewer Yeah, Hi. So how much relevant experience do you have in Power BI? candidate So I have around 3.5 years experience. Interviewer OK. And how much will you rate yourself out of 10? candidate So rate myself 8 out of 10 in Power BI. Interviewer OK, fine. OK, let's start with the first question. So suppose you are in Power Query Editor. So if we have two or more queries that you want to append, So what should be the like? What should be the minimal condition to append those two queries? candidate OK, so I have two queries you need to append right? OK so I think so you can just append it. The one thing that should be there is they should have same number of columns and if they don't have same number of columns I think that there will be a problem that you'll have you know? If there are extra columns in either of them, the other table will show nulls. Yeah, I think so. Yeah, that's that's the only thing that's required. Interviewer OK, so only the number of columns should be same. And what about their data types if the data types do not? candidate Yeah, yeah yeah no, no no. Their data type should also be the same. So you know the number of columns should be same, the name should be same and the data type should be same. So if there's some extra columns you know in either of them or if the data type or name is different. Then you know they'll consider it as a new, new column. So you're not. They'll take nulls. So, like, these are the three basic things that you do that we have taken. Take care. Interviewer OK. And have you heard about query folding? candidate Yeah, so query folding is something you know. What happens is if you're using some database as a source. I know SQL as as like for SQL I'm sure of. You know if you there are some transformations that can be done in the SQL side it will be faster because you know SQL is made for that. For the tram those things maybe somewhere clause or some you know some columns some some things. So query folding happens in Power BI, you know it automatically happens. In Power BI, if you have SQL as the source and if you've written your query in such a manner that you know if you've used native query, most of the times the query folding happens. So this is, you know, optimization technique that we can use so that you know the processing would be faster. Something like that, yeah. Interviewer OK, fine, OK, suppose can you open your chat section? I'm sending something and you have to answer accordingly. OK. So OK, suppose you have a column which contains values like this which I'm sending 0114. OK, something like this you have in all the rows. OK, OK, so as you can see this is a kind of a date, right? Yeah, but you have a column which contains these these, these kinds of records and the data. The data type of that column is number. OK as as they are representing numbers. No if I if I want to convert it to date how will you do that thing? candidate Maybe, you know I have never done this, but what we can do is we can go and we can change the data type to date and then once we go you know once we change the data type it is also an option that what kind of data type that you want. So if you maybe you can check it from there that if it is present maybe I think it's written 2022, zero, 114th I think so it's 14th January. 2020 yeah, so we can you know check it there that you know our data is present in this manner that you know first year is present, then month is present and then date is present. There's an option that you know there's an option for this that you know if you want your date to be this in this particular manner you can just check that so it will automatically take OK, this is your year, the first thing is taken as your the 1st 4 digits, the next two digits are taken as month month and then last two digits are taken as the date. So yeah, this. Interviewer Is so you are saying so you are saying. If we are going to directly change its data type from number to date, it will work right As for you. candidate Yeah, we have to change and we also have to go to the date. You know, once change it, there's an option of, you know, checking what that kind of date is. You know date we are using it's MMDD format or it's your month, your your, your date like that format. So you have to change, you have to check that as well then I think so it can be done. This is what you are, yeah. Interviewer So Shavika, suppose you have a column which contains record something like this which I'm sending right now on your chat section. Suppose something like this is written Rupees 1000. Just a second, I'm sending you OK Rupees 1000 something like this five $5000 OK. Something like this, it is written and you have a column like this. Now if I want to take out number of number from this column and create a new column where I will only have the numbers instead of rupees and dollar then how will I create this in power query editor. OK so something like this you have different currencies written with their numerical part something like this that you're that you're seeing on the screen. So how will you take out the number from this column? candidate Yeah, like if I think so, if you know, if the currency symbol was present only at one place, I could have or and it was only one currency, you know, I could have used a custom way to split the columns, you know, using a custom delimiter. But can you give me a minute please? I'm just thinking, is that fine? Yeah. Interviewer Yeah, sure. candidate OK, we can. OK, and we have to do it in Power Query only, correct? Interviewer Yeah.0024
- SQL DesignIn Tech Talk·August 16, 2023007
- Need distinct count flag with yes or no to apply in the visual level in power biIn Ask Questions·September 29, 20231. Create a Measure for Distinct Count: DistinctCountProduct = COUNTROWS(SUMMARIZE('TableName', 'TableName'[ProductID])) 2.Create a Flag Measure: DistinctCountFlag = IF([DistinctCountProduct] > 10, "Yes", "No") 3. Apply Visual-Level Filter: • Add a visual to your Power BI report. • Drag the DistinctCountFlag measure to the "Values" area of the visual. • Go to the "Visualizations" pane and select the "Filter" icon. • Under "Visual level filters", find the DistinctCountFlag measure. • Set the filter condition to show values where the measure is "Yes" (or "No" based on your requirement). Now, the visual will only display data when the distinct count condition you've set is met. 4. Customize as Needed: You can adjust the conditions in the DistinctCountFlag measure to fit different criteria or apply to different columns as needed.002
- Power BI Experienced Live Interview Questions with AnswersIn Tech Talk·July 20, 2023Please find attached Word file Live Interview Questions with Answers0036
- LTI Mindtree Interview Power Bi Experienced live Q & AIn Tech Talk·July 21, 2023Interviewer: Good afternoon. Candidate: Hello, Sir, very good afternoon. Interviewer: Yes, that's another thing and frankly speaking, I forgot about our call, but thanks for reminding me because I'm working on, I was doing multiple things. Candidate: OK, OK, no problem Sir. Interviewer: Uh, let me just pull up your profile. Could you please give me a brief overview of where you are currently working and what your day-to-day activities entail? Additionally, could you share information about the size of your team? Are you an individual contributor, or do you have specific responsibilities assigned to you? I'm interested in learning more about the work you are currently engaged in. Candidate: Thank you for asking about my company and my day-to-day activities. I am currently working at CSM Technology, a highly reputed IT organization in Odisha. We handle approximately 85% of the IT work for the Odisha Government. While it is a private company, our work is closely aligned with the government's requirements. As a Power Bi Developer, my primary focus is on data analysis. My daily activities involve understanding our clients' problems and finding solutions through data analysis or creating dashboards. To achieve this, we collect data from various sources, which often requires cleaning as the data may not always be in a pristine format. Once the data is clean, we load it into the Power BI environment and establish relationships between different tables. This allows us to identify suitable key performance indicators (KPIs) and create various charts and visualizations to analyze the data further. After analyzing the data and crafting meaningful insights, we create reports and publish them to our server. Finally, we share these reports or dashboards with our clients to provide them with valuable insights. In our team, we have a total of 14 members, including myself. It's a relatively small team, which means we collaborate closely and are involved in the entire process, from data collection to report sharing. Apart from Power BI, we also use other tools like Tableau and SSAS for data analysis. I have experience working with all three tools, allowing me to leverage the best-suited tool for specific analytical requirements. Interviewer: It says that, OK, so SASS, you're using SASS, you're using Tableau, you're using power BI, right? Candidate: Yes, Sir. Interviewer: And what about your experience with SQL and Ms. Excel? Candidate: When I joined CSM Technology, my role was that of a Database Engineer. So, I have extensive experience working with Microsoft SQL Server and SQL Azure. I can confidently say that I am proficient in SQL 11 and have utilized it in various projects. As for Ms. Excel, we do use it in our analysis, but I must admit that I don't have extensive experience with it. I am familiar with the basics of Ms. Excel, which are essential for data analysis, but I haven't delved into the advanced features yet. However, I am always open to learning and enhancing my skills further in both SQL and Ms. Excel as needed for my role. Interviewer: Okay, but what do you know about Excel? Do you have experience with functions like VLOOKUP, IF, and COUNTIF in Excel? Have you worked with these functions before? Candidate: Yes, sir. I have experience with Excel functions. I am familiar with VLOOKUP, IF, and COUNTIF functions, and I have used them in various projects. Interviewer: Great! How many projects have you completed using Power BI? Candidate: I have completed a total of three projects using Power BI. These projects involved creating office dashboards, a quantified dashboard, an IGMS dashboard for a mining project, and a dashboard to represent passport data. Interviewer: Could you please tell me about the nature of the data you have worked with? What kind of data are you dealing with? Is it financial data, healthcare data, HR data, or something else? Candidate: The nature of the data that I have worked on includes mining data, HR data, financial data, and citizenship data. Interviewer: Excellent. Now, let's discuss DAX functions. Which DAX functions have you used in your projects? Candidate: In my projects, I have used several DAX functions, such as AVERAGE, COUNT, MAX, MIN, SUM, TOPN, ADDCOLUMNS, EXCEPT, GROUPBY, UNION, UPPER, LOWER, and REPLACE, along with various time intelligence functions like DAY, MONTH, YEAR. Interviewer: Okay, let's consider a scenario where I have a chart showing the count of OC citizens on a monthly basis. For example, in January, the count is 100, and in February, the count is 200. However, when I view the bar chart, the months appear shuffled, like January, March, October, and November. I want them to be in proper order, like January, February, March, and so on. How can I arrange the months correctly in the chart? Candidate: To achieve the desired order, we can use the "Sort by Column" feature. First, go to the "Data" tab and select the "Month Number" column from the table. The "Month Number" column is an auto-generated column by Power BI, representing January as 1, February as 2, March as 3, and so on. Once you've selected the "Month Number" column, go to the "Modeling" tab and choose the "Sort by Column" option. In the drop-down, select "Sort by month number," and this will arrange the months correctly in the chart. Interviewer: Impressive! Let's talk about data modeling. How many types of relationships can you create between two tables in Power BI? Candidate: In Power BI, you can create three types of relationships: one-to-one, one-to-many, and many-to-many relationships. Interviewer: Correct. Now, suppose you have created a bookmark, but when you switch between pages, your slicer selections are not retained. How can you fix this issue? Candidate: To fix this issue, you can go to the data tab, select the month number column, go to the Modeling tab, and choose "Sort by column" by selecting the "Sort by month number." This will ensure the month names are sorted properly. Interviewer: Good. Now, have you worked with the TOPN function in Power BI? Can you explain how to achieve dynamic TOPN using parameters? Candidate: Yes, I am familiar with the TOPN function. To achieve dynamic TOPN using parameters, you can create a parameter for the desired number of top items. Then, use the TOPN function in your DAX expression and reference the parameter in the "N" argument of the TOPN function. Interviewer: Excellent. Now, let's discuss query merge and append. What is the difference between append and merge queries? Candidate: When you append queries, you stack rows from two tables on top of each other, combining them vertically. Merge queries, on the other hand, combine columns from two tables based on matching data, creating a new table with additional columns. Interviewer: Very good. How many types of joins have you used in Power BI, and can you explain the role of a LEFT JOIN? Candidate: In Power BI, I have used six types of joins: LEFT JOIN, RIGHT JOIN, INNER JOIN, FULL OUTER JOIN, LEFT OUTER JOIN, and RIGHT OUTER JOIN. The role of a LEFT JOIN is to return all values from the left table and the corresponding matches from the right table. If there is no match in the right table, you see a null value in the result. Interviewer: Correct. Let's talk about star schema and Power BI. Can you explain how to create a star schema? Candidate: In a star schema, the fact table is at the center, surrounded by dimension tables. Each dimension table has a single relationship with the fact table, creating a star-like structure. Interviewer: Good job. Now, let's discuss bookmarks in Power BI. How can you retain slicer selections when switching between pages using bookmarks? Candidate: To retain slicer selections when switching between pages, you need to enable "Keep all filters" in the bookmark settings. This will maintain the slicer selections across different pages. Interviewer: Correct. You're doing well. Finally, have you worked with index columns in Power Query, and why do we need them? Candidate: Yes, I have worked with index columns in Power Query. Index columns are used to assign a sequential number to each row in a table, which helps in organizing the data and improving performance. Interviewer: Well done. That concludes the interview. Do you have any questions for me? Candidate: Yes, I do. Can you tell me more about the company culture and any opportunities for growth within the organization? Interviewer: Sure, our company values teamwork, innovation, and continuous learning. We offer various training programs and opportunities for career advancement based on performance and skills. We encourage employees to take on new challenges and grow within the organization. Candidate: That sounds great. Thank you for sharing that information. Interviewer: You're welcome. Thank you for your time and impressive performance in the interview. We will get back to you with our feedback soon. Have a wonderful day! Candidate: Thank you, Sir. I look forward to hearing from you. Have a great day too. Goodbye. Interviewer: Goodbye. Take care!00103
- Power BI Real Live interview questions and answers for 3+ years experienceIn Tech Talk·August 6, 20230017
- Can we integrate talend and GCP through pipelinesIn Questions & Answers·July 20, 2023Yes, it is possible to integrate Talend and Google Cloud Platform (GCP) through data pipelines. Talend is a powerful data integration and ETL (Extract, Transform, Load) tool that provides various connectors and components to facilitate data integration across different systems and platforms. To integrate Talend with GCP, you can leverage Talend's connectors for GCP services such as Google Cloud Storage, BigQuery, Pub/Sub, and others. Talend allows you to design and develop data pipelines that interact with GCP services to perform various data integration tasks. Here's a general workflow of integrating Talend with GCP through data pipelines: Design and Develop Talend Job: Use Talend Studio, the graphical development environment, to design and develop the data integration job that includes the required components and transformations. Talend provides pre-built connectors for GCP services, enabling seamless interaction with GCP resources. Connect to GCP Services: Utilize Talend's GCP connectors to establish connections with GCP services like Google Cloud Storage, BigQuery, and Pub/Sub. Provide the necessary authentication credentials and configurations to authenticate and connect with the respective GCP services. Data Extraction and Transformation: Use Talend's data integration capabilities to extract data from various sources, perform necessary transformations, and prepare the data for loading into GCP services. This can involve cleansing, filtering, aggregating, or any other required data transformations. Load Data into GCP: Utilize Talend's GCP connectors to load the transformed data into GCP services. For example, you can load data into Google Cloud Storage for storage, import data into BigQuery for analytics and querying, or publish data to Pub/Sub for real-time data streaming. Orchestration and Monitoring: Talend provides features for job scheduling, orchestration, and monitoring. You can schedule the execution of Talend jobs at specific intervals or trigger them based on events. Additionally, you can monitor the job execution, handle errors, and capture relevant metrics for performance analysis. By integrating Talend and GCP through data pipelines, you can leverage the strengths of both platforms to enable seamless data integration, transformation, and loading processes. This integration allows you to harness the power of GCP services for data storage, analytics, and real-time data processing while benefiting from Talend's robust data integration capabilities.0012
- steps to set up LDAP integration and manage permissions in Jira Data Center:In Ask Questions·October 24, 2023Here are the general steps to set up LDAP integration and manage permissions in Jira Data Center: Step 1: Set up LDAP Integration 1. Log in to Jira as an administrator. 2. Navigate to the Jira Administration Console. 3. Go to "User Management" and select "User Directories." 4. Click on "Add Directory" and select "LDAP." 5. Enter your LDAP server details and credentials. 6. Test the connection to ensure it is working correctly. 7. Configure the user and group mappings to determine how Jira should map LDAP users and groups to Jira users and groups. 8. Save the configuration. Step 2: Configure Permissions Once the LDAP integration is set up, you can then configure permissions for LDAP users and groups within Jira. 1. Go to the Jira Administration Console. 2. Navigate to "Issues" and select "Permission Schemes." 3. Select the permission scheme you want to configure. 4. Add the LDAP groups or users to the appropriate permissions. 5. Save the changes. Step 3: Test Permissions After configuring the permissions, you should test to ensure that LDAP users have the correct permissions. 1. Log in as an LDAP user. 2. Verify that you can access the expected features and data based on the permissions you configured. Please note that the exact steps may vary depending on your specific LDAP setup and Jira configuration. If you have any specific requirements or need further assistance, please let me know.003
- Full SQL notes clearly and understandable to sql beginner levelIn Questions & Answers·August 5, 2023Below are some clear and understandable notes for beginners to SQL (Structured Query Language): Introduction to SQL: SQL (Structured Query Language) is a programming language used to manage and manipulate relational databases. It allows you to perform various operations on data, such as querying, inserting, updating, and deleting records in a database. Basic SQL Commands: SELECT: Used to retrieve data from one or more database tables. SELECT column1, column2 FROM table_name; 2. INSERT: Used to add new records into a table. INSERT INTO table_name (column1, column2) VALUES (value1, value2); 3.UPDATE: Used to modify existing records in a table. UPDATE table_name SET column1 = value1, column2 = value2 WHERE condition; 4. DELETE: Used to remove records from a table. DELETE FROM table_name WHERE condition; Creating a Table: To create a new table, use the CREATE TABLE statement with column names and data types CREATE TABLE table_name ( column1 datatype, column2 datatype, ... ); Constraints: Constraints are rules applied to columns to maintain data integrity. Some common constraints are: NOT NULL: Ensures a column cannot have NULL values. UNIQUE: Ensures each value in a column is unique. PRIMARY KEY: A combination of NOT NULL and UNIQUE, used to identify a unique row in a table. FOREIGN KEY: Establishes a link between two tables, referencing a primary key in another table. Filtering Data: You can use the WHERE clause to filter data based on certain conditions in a SELECT statement. SELECT column1, column2 FROM table_name WHERE condition; Sorting Data: To sort the results of a SELECT statement, use the ORDER BY clause. SELECT column1, column2 FROM table_name ORDER BY column1 ASC/DESC; Joins: Joins are used to combine data from multiple tables based on a related column. Common types of joins are: INNER JOIN: Returns only the matching rows from both tables. LEFT JOIN (or LEFT OUTER JOIN): Returns all the rows from the left table and matching rows from the right table. RIGHT JOIN (or RIGHT OUTER JOIN): Returns all the rows from the right table and matching rows from the left table. FULL JOIN (or FULL OUTER JOIN): Returns all the rows when there is a match in either the left or right table. Grouping Data: The GROUP BY clause is used to group rows that have the same values in one or more columns. SELECT column1, COUNT(*) FROM table_name GROUP BY column1; Aggregate Functions: Aggregate functions perform calculations on grouped data. Common aggregate functions are: COUNT: Returns the number of rows. SUM: Returns the sum of values in a column. AVG: Returns the average of values in a column. MAX: Returns the maximum value in a column. MIN: Returns the minimum value in a column. Updating Multiple Records: You can update multiple records at once using the WHERE clause in the UPDATE statement. UPDATE table_name SET column1 = value1 WHERE condition; Deleting Multiple Records: You can delete multiple records at once using the WHERE clause in the DELETE statement. DELETE FROM table_name WHERE condition;005
- Power Bi NotesIn Ask Questions·October 12, 2023what is power bi powerbi is visulization and reporting tool from microsoft. why power bi less cost Power bi power power query - 7 days - ETL - Extrat transformation tool power view - 7 days - view - report power pivot - 7 days - data modeling Power bi service - 3 days - sharing and How power bi works - we dont need any programming skills 1.sql 2. basic excel 3. data modeling power bi can connect 99 data sourcec Power Query - ETL - tranformations Excel sql server PoWerbi desktop - power query - ETL - - POWERService - users Power bi install - licences power bi desktop power bi licence Free we can deveop the report Pro We can develop the report and share the report - cost 9.99 $ 1GB Premium 5000$ pOWER Bi connection methods Import - offline - Excel , text , csv Direct - any database - sql server, postgre, oracle Live - Azure,ssas How exactly power bi works why should Powerbi - trending - we can connect 99 data sources - Power bi cost - very less - compare to other tools - other tools - 100$ Power bi - User friendly tool Power bi desktop - Excel - Sql server - Live - Will have one project after this course if you want to do certification - PL 300 certification - Premium - online files - twitter - Trending Along with Power BI - Add on advancatges courses 1. ETL - SSIS 2. Reporting tool - Power BI Fullstack - powerbi report builder 3. Power automate 4. power apps 5. data warehouse - snowflake 6. database - Sql server, oracle, ****Day 2 Data connection methods Import direct Live 1.We will import the data 1.Data (http://1.Data)will be source 1.data (http://1.data)will be source 2.We can connect 99 data sources 2.Only databases (sql server) 2.SSAS 3.Wecan Perfome all DAX funcetion 3.Limited (http://3.Limited)DAX 3.All dax fucntions 4.1GB - Pro & Premium - 10gb 4.No (http://4.No)data limit 4.1GB 5.Fast (http://5.Fast)perfomrance 5.slow performance 5.fast (http://5.fast)performance 6.Not fresh data 6.Fresh latest data 6.Latest data Day 3*** Merge queries combine tables horizontally, while append queries combine tables vertically. Merge queries require at least one matching column in each table, while append queries require matching columns with the same data types Power Query - Append and Merge - Rows Apeend - we can join 2 or more tables (sheets) 1. Normal Append - 2. Case sensitive 3. Column order may not be the same Merge -to join the 2 or more tables. - Columns Left join - All the records from left table and matching records from right table right join - Allt the records from right table and matchig from the left table Full join - Allthe records from both the tables Inner join - Matching records from the both the tables Right anti join - NoT MACTHING Records from right table left anti join -not matcing records from left table Duplicate table rEFERANCE TABLE Advance Editor - M- launguage - M code Day 4*** Power Query - Conditional Column - (IF else) - 2 or more conditions Coulmn from examples - given exmaples Manage parameter - Dynamic filter in source level Advance Editor - M Luanguage CODE - Day 8- Data Modeling - Relationship between fact and dimension table. Fact - Transcation table which more num we can perform - Agrregate - Measure (Metric) Dimension - More Text data Product table - customer table Product table - Dim Prod id - Produ name - pro Qty - Pro price - mb 001 - Ramayana- 1 - 50 002 - mahabaha- 1 - 40 Custmer table cusoter code- produ code - date - price - Qty - Fact - 500 mb 134 - 001 - 14 - 1 123 - 002- 15- 2 145 - 123 Schema - Star Schema - Fact table is connecting directly with Dim table Snow flake - Fact table to connectionf dim table and this dim is connectiing another dim table Fact table is indirectly conect with another dim table is called snowfale schema. Fact - Dim More num - More text - Primary Foreign key Star schema - SNow flake Large date - Less date 2. tables are combine - 1. More table 3. denormalize 2. Table spi 4 Reading fast 3. Normalization 4. writing slow 4. Reading slow and writing fast. Relationships - to get the proper results in report - we should give the relationship Autodetect - Creta relations ship- Edit - Delete relationship How many cordinalities 1. One to one 2. One to many 3. Many to one 4. Many to many If we have multiple databases how to give relationships- tomrow i need to Day 9- Data modeling - Relationships 1. create relationship - Manually created relationship 2. Auto detect relationship - automatically 3.Edit relationship - Edit relationship 4. delte relationship - delete the relationship Cardinalites - 1. one to many - wil create one to many - Single - both 2. Mnay to one - will create Many to one - single - both 3. One to one - 4. Manay to many Cross filter - single and both (BI) ONE TO ONE - BI DIRECTIONAL HOWEVER WE CANT CHANGE TO SINGLE Many to many - by deafult i twill be bi directional we cant change to single direction Active and inactive relationship .....tomrow will discuss taking one example f mulitple relationships Bar Charts and Column Charts:these visuals to display financial metrics, market trends, or industry performance. Line Charts:visualize changes in key performance indicators, economic indicators, or business growth rates. Pie Charts and Donut Charts: these visuals to represent market share, industry distribution, or customer segmentation. Map Visuals:visuals to analyze regional economic indicators or market penetration. Matrix Visuals:matrix visuals to show complex relationships, such as industry performance by sector and region. Scatter Plots:to analyze relationships between economic factors or business metrics. Gauges and Cards:visuals to display critical information like financial ratios, credit scores, or risk assessments. KPI Indicators:use KPI indicators for metrics such as profitability ratios, liquidity ratios, or industry benchmarks. Hierarchy and Drill-Down Visuals:visuals to provide a top-level overview of industries, markets, and then allow users to explore specific companies or segments. Sankey charts: Financial analysts can use Sankey charts to visualize cash flow within a business, showing how money is allocated to different expenses, investments, or revenue streams. Relational Database Design: Think of it like a spreadsheet with tables, rows, and columns. Good for storing everyday data, like names, addresses, and orders. Helps keep data organized and prevents repeating the same information. Works well for applications where data needs to be changed frequently. Multidimensional Database Design: Imagine a data cube with different layers. Great for analyzing and finding patterns in data. Especially useful when you want to look at data from different angles or perspectives. Perfect for making reports and finding insights from big datasets.0030
- To execute a Python script from Power BI when pressing a submit button, you'll need to use a combination of Power AutomateIn Ask Questions·October 14, 2023To execute a Python script from Power BI when pressing a submit button, you'll need to use a combination of Power Automate and a custom Power BI button action. Here's a step-by-step guide: 1. Set Up Power Automate: 1. Create a new Flow: • Go to Power Automate.(https://flow.microsoft.com/) • Click on + Create and select Instant flow. • Name your flow and choose the trigger as PowerApps. 5. Add a Python Script Action: • Search for the Execute Python script action and add it to your flow. • Configure the action to run your Python script. You might need to provide the path to your Python script and any necessary arguments. 8. Save the Flow. 2. Integrate with Power BI: 1. Add a Button in Power BI: • In Power BI Desktop, go to the Insert tab. • Click on Buttons and choose a button type (e.g., Blank). • Place the button where you want it on your report. 5. Configure the Button Action: • With the button selected, go to the Format pane. • Under the Action card, turn the action On. • Set the Type to Web URL. • For the URL, use the URL of the Power Automate flow you created. This will trigger the flow when the button is clicked. 10. Publish the Report: • Save and publish your report to the Power BI service.005
- Power Bi most common interview Q & AIn Questions & Answers·August 1, 2023What is RLS? How many types are there? Answer: RLS stands for Row-Level Security. It is used to control access to data at a row level based on user roles and permissions. There are two types of RLS: Role-Based and User-Based. What is incremental refresh, and what are the two parameters used in incremental refresh? Answer: Incremental refresh is a feature in Power BI that allows you to refresh only a portion of your data to improve performance. The two parameters used in incremental refresh are "RangeStart" and "RangeEnd," which define the time period for the refresh. Difference between SUM and SUMX: Answer: SUM is an aggregation function used to calculate the total of a column in a table. SUMX is an iterator function that calculates the sum of an expression over a table, considering row context. How many types of licenses are available? Answer: There are mainly two types of licenses in Power BI: Power BI Pro and Power BI Premium. Difference between Pro user & Premium user: Answer: A Pro user has access to Power BI service with individual licenses, while a Premium user accesses Power BI service through capacity-based licensing, enabling the sharing of reports and dashboards with free users. What are Gateways, and how many types of gateways are there? Answer: Gateways are used to connect on-premises data sources to Power BI service. There are two types of gateways: Power BI On-premises data gateway and Power BI Personal gateway. What is Power BI service? Answer: Power BI service is a cloud-based platform where you can publish, share, and collaborate on Power BI reports and dashboards. Difference between calculated column and Measure: Answer: A calculated column is a column created in a table with a DAX formula that is evaluated row-by-row and stored in the table. A measure is a calculation that works with aggregated data and provides results based on user interactions. What are the roles in the workspace (Admin, Member, Viewer, and Contributor)? Answer: In a Power BI workspace, there are four roles: Admin: Full control over the workspace, including managing access and settings. Member: Can edit and publish content within the workspace. Viewer: Can view content within the workspace but cannot make changes. Contributor: Can contribute content to the workspace but has limited administrative rights.0021
bottom of page