top of page

Type
Category
108 items found for ""
- How to configure import mode for PBIRS report?In Ask QuestionsSeptember 29, 20231. Power BI Reports: * Power BI reports on PBIRS support both DirectQuery and Import modes, similar to the Power BI Service. * In Import mode, data is imported into the Power BI file and refreshed based on the schedule you set up on the Report Server. * In DirectQuery mode, data is queried in real-time from the data source when the report is viewed. 1. Paginated Reports (Report Builder Reports): * Paginated reports do not have an "import mode" like Power BI reports. Instead, they always run queries against the data source in real-time when the report is viewed or when it's scheduled to run (for subscriptions). * The data in paginated reports is not stored within the report file itself. Instead, the report definition, layout, and query are stored, and the data is fetched each time the report is run. To answer your question directly: * No, Power BI Report Server paginated reports (made via Report Builder) do not support an "import mode" like Power BI reports. They always fetch data in real-time from the data source when the report is viewed or executed. If you want to reduce the load on your data source or improve report performance, consider using caching or snapshots for paginated reports. Caching saves a copy of the report with the data, and snapshots save a version of the report with data at specific points in time. Both can be configured in the report properties on the Report Server00
- Are the Ciphers ECDHE-RSA-AES128-SHA256 and ECDHE-RSA-AES256-SHA384 strong?In Ask QuestionsSeptember 29, 2023The ciphers you've listed are considered strong and safe for modern applications. Let's break down your concerns: 1. GCM vs. CBC: * GCM (Galois/Counter Mode) is an authenticated encryption mode of operation that provides both data authenticity (integrity) and confidentiality. It's considered secure and efficient. * CBC (Cipher Block Chaining) is an older mode of operation. While it's still widely used, it has some vulnerabilities, most notably the BEAST attack, as you mentioned. However, BEAST primarily affects TLS 1.0 with CBC-mode ciphers. With the mitigations in place in modern browsers and the fact that you've disabled TLS 1.0, the risk is minimized. 1. Cipher Naming: * The names "ECDHE-RSA-AES128-SHA256" and "ECDHE_RSA_WITH_AES_128_CBC_SHA256" refer to the same cipher suite. The difference in naming is just a matter of notation between different tools and documentation. * "ECDHE-RSA-AES128-SHA256" uses CBC mode (as indicated by the absence of "GCM" in the name) and SHA-256 for message authentication. 1. Safety of the Ciphers: * All the ciphers you've listed are currently considered strong. The ECDHE (Elliptic Curve Diffie-Hellman Ephemeral) ensures forward secrecy, meaning that even if an attacker gets hold of a server's private key, they won't be able to decrypt past communications. * The AES (Advanced Encryption Standard) ciphers, whether 128-bit or 256-bit, are robust and widely accepted as secure. * The SHA-256 and SHA-384 are cryptographic hash functions from the SHA-2 family and are considered secure. 1. Recommendation: * While the ciphers you've listed are strong, if you want to further harden your security posture, you might consider disabling the CBC-mode ciphers ("ECDHE-RSA-AES128-SHA256" and "ECDHE-RSA-AES256-SHA384"). This would leave you with only the GCM-mode ciphers for TLS 1.2 and the TLS 1.3 ciphers, which are all strong. * However, be cautious when disabling ciphers, as it might affect compatibility with older clients. Always test changes in a staging environment before applying them to production. In summary, your current cipher suite selection is strong, but you can further restrict it by removing CBC-mode ciphers if you're aiming for a stricter security profile and are not concerned about compatibility with some older clients. #security #encryption #tls1.200
- Power BI Project End to End- HR AnalyticsIn Power BI ProjectsAugust 27, 2023If I were a candidate discussing this Power BI project in an interview, here's how I would explain each topic: 1. Data Cleaning & Processing in Power BI: In this project, we started by importing raw HR data into Power BI. Before we could visualize and analyze the data, we needed to clean and prepare it. This involved identifying and handling missing values, correcting data types, and removing duplicates. Power BI's data transformation capabilities, particularly Power Query, were used for this purpose. 2. Power BI Dashboard Setup: Once the data was cleaned and processed, we set up the foundation for our HR analytics dashboard. This included creating a new Power BI report and adding various visuals, which would collectively form the dashboard. 3. Import Data in Power BI: The next step was to import the cleaned HR data into Power BI. This involved connecting to the data source (e.g., Excel, SQL database) and loading the data into the Power BI environment. 4. Power Query in Power BI: Power Query was a crucial tool in this project. We used it to transform and shape the data further. This included merging multiple data sources, applying advanced data transformations, and creating custom columns to derive insights. 5. DAX in Power BI: DAX (Data Analysis Expressions) played a significant role in the project. We used DAX formulas to create calculated columns and measures. For instance, we could calculate metrics like employee turnover rate, average salary, or performance indexes using DAX. 6. Measures and Calculations in Power BI: Within Power BI, we defined measures and calculations using DAX. Measures are dynamic calculations that respond to user interactions and slicer selections. This allowed us to provide real-time insights based on user needs. 7. Charts in Power BI: Charts and visuals are at the heart of data visualization. We leveraged various types of charts, such as bar charts, line charts, and pie charts, to represent HR metrics visually. This made it easier for users to understand trends and patterns. 8. Filters and Slicers in Power BI: To enhance interactivity, we implemented filters and slicers in the dashboard. These tools allowed users to select specific criteria, departments, time periods, or any other relevant data points. The visuals automatically adjusted to reflect the user's selections. 9. Dashboard in Power BI: The dashboard itself was a collection of interconnected visuals, charts, and tables. It presented a comprehensive view of HR analytics, enabling users to explore and gain insights at a glance. 10. Export Power BI Dashboard - Insights from Dashboard: Users could export the dashboard or specific visuals in various formats (e.g., PDF, PowerPoint). This was helpful for sharing insights with stakeholders who might not have direct access to Power BI. The dashboard's insights provided actionable information for HR decision-making.00
- Forum rulesIn General Discussion·July 18, 2023We want everyone to get the most out of this community, so we ask that you please read and follow these guidelines: Respect each other Keep posts relevant to the forum topic No spamming007
- Welcome to the ForumIn General Discussion·July 18, 2023Share your thoughts. Feel free to add GIFs, videos, hashtags and more to your posts and comments. Get started by commenting below.002
- 1. Artificial Intelligence (AI) Revolution 🤖In Tech Talk·July 19, 2023AI is at the forefront of innovation, transforming industries and revolutionizing the way we interact with machines. From AI-driven virtual assistants to smart homes and autonomous vehicles, the potential of AI is limitless. Let's share our thoughts on how AI impacts our daily lives and its ethical implications.003
- 2. 5G Connectivity and Beyond 📶In Tech Talk·July 19, 2023The advent of 5G technology promises lightning-fast internet speeds, enabling seamless communication and empowering the Internet of Things (IoT). How do you envision the 5G era unfolding? Let's explore its potential in transforming businesses and enhancing user experiences.002
- I want add my broker api in power bi for live feed plz helpIn Tech Talk·August 16, 2023Adding Broker API in Power BI Here's a general outline of the steps you can follow: Get API Access: Ensure you have access to your broker's API and the necessary authentication credentials (API key, secret, token, etc.). Open Power BI: Launch Power BI on your computer. Choose Data Source: Click on "Get Data" in the Home tab to choose your data source. Select Web or JSON: Depending on your broker's API, you can select either the "Web" option or the "JSON" option as your data source. Enter API Endpoint: Enter the API endpoint URL provided by your broker in the "URL" field. This URL is where you'll be making API requests to fetch the live feed data. Configure Authentication: Depending on the authentication method your broker uses (e.g., API key, OAuth), you may need to configure authentication settings. If it's API key-based, you can often include the API key in the URL itself or provide it in headers. If it's OAuth, you might need to enter the appropriate credentials. Transform Data (Optional): Power BI might load the data as-is or allow you to transform it. You can use the Power Query Editor to clean, filter, or modify the data before using it in your reports. Load Data: After configuring authentication and optionally transforming the data, click on the "Load" button to load the live feed data into Power BI. Create Visualizations: Once the data is loaded, you can create visualizations like charts, tables, and graphs using the "Visualizations" pane. Set Refresh Schedule: If you want the data to update automatically, you can set a refresh schedule in Power BI. Depending on your version of Power BI, there might be limitations on how often you can refresh data in the free version. Save and Publish: After creating your visualizations and setting up refresh, you can save your Power BI file and publish it to Power BI Service if you want to share it with others.0016
- SQL DesignIn Tech Talk·August 16, 2023007
- Most Important questions asked by every interviewerIn Tech Talk·August 17, 2023Interviewer: What is a tile in Power BI? You: In Power BI, a tile is a visual representation of a report element that you can pin to a dashboard. It's essentially a snapshot of a visual, table, chart, or other report element that provides a quick overview of key insights. Tiles allow users to access important information at a glance without having to navigate through the entire report. Interviewer: Can you describe your daily routine as a Power BI developer? You: Certainly! My typical day involves a combination of tasks. I start by reviewing any new requirements or changes from stakeholders. I then work on data modeling, transforming and cleaning data using Power Query, and creating visuals in Power BI Desktop. Once the visuals are ready, I create reports, add interactivity, and create calculated measures using DAX. Finally, I publish the reports to Power BI Service, where I fine-tune dashboards, ensure data refresh, and collaborate with team members. Interviewer: What have you worked on with Power Pivot? You: In Power Pivot, I've primarily focused on creating data models within Excel workbooks and Power BI Desktop. I've used Power Pivot to combine multiple data sources, define relationships, and create calculated columns and measures using DAX. This has allowed me to build interactive reports and dashboards that offer in-depth insights to end-users. Interviewer: What is a query context in Power BI? You: A query context in Power BI refers to the subset of data that is temporarily filtered or modified based on the interactions and selections made by users. It's essential in calculating measures accurately using DAX, as DAX expressions take into account the current row's context within visuals. This context includes filters, slicers, and selections applied to the visual or report. Interviewer: How do we refresh a dashboard in Power BI? You: To refresh a dashboard in Power BI, you would typically need to refresh the underlying dataset or data source. This involves going to Power BI Service, opening the respective dataset, and initiating a manual refresh. Once the data refresh is complete, the visuals and reports within the dashboard will reflect the updated data. Interviewer: Can we refresh a dashboard automatically? You: Yes, we can set up automatic data refresh for a dashboard in Power BI Service. This ensures that the data displayed in the dashboard is always up-to-date without manual intervention. However, automatic refresh depends on data source connectivity, permissions, and the refresh schedule you configure. Interviewer: How do you schedule a dashboard refresh? You: To schedule a dashboard refresh, you can navigate to Power BI Service, open the dataset associated with the dashboard, and set up a refresh schedule. This involves specifying the frequency (daily, weekly, etc.) and time for the refresh to occur. Keep in mind that the availability of refresh options might depend on your Power BI licensing and connectivity to data sources. Interviewer: How many data types have you worked with in Power BI? You: I have experience working with a wide range of data types in Power BI, including numerical, text, date/time, boolean, and hierarchical data types. Additionally, I've worked with custom data types created using Power Query's "Add Custom Column" feature to enrich data during the transformation process.0017
- science-related general knowledge questions along with their answersIn Questions & Answers·August 18, 2023Question: What is the chemical symbol for the element oxygen? Answer: O Question: What is the process by which plants convert light energy into chemical energy to produce food? Answer: Photosynthesis Question: What is the smallest unit of matter? Answer: Atom Question: What is the force that opposes the motion of objects through a fluid (liquid or gas)? Answer: Friction Question: What is the process by which water vapor turns into liquid water? Answer: Condensation Question: Which gas is most abundant in Earth's atmosphere? Answer: Nitrogen Question: What is the study of the Earth's physical structure, processes, and history? Answer: Geology Question: What is the process by which a solid changes directly into a gas without passing through the liquid state? Answer: Sublimation Question: What is the SI unit of electric current? Answer: Ampere (A) Question: What is the study of celestial bodies such as stars, planets, galaxies, and black holes? Answer: Astronomy Question: What is the process by which an organism produces offspring that are genetically identical to itself? Answer: Asexual reproduction Question: What is the process by which an electric current passes through a liquid, causing chemical reactions and the separation of materials? Answer: Electrolysis Question: What is the force that attracts any two masses toward each other? Answer: Gravity Question: What is the unit of measure for frequency? Answer: Hertz (Hz) Question: What is the chemical process that releases energy from food in the presence of oxygen? Answer: Cellular respiration Question: What is the outermost layer of the Earth called? Answer: Crust Question: What is the process by which a liquid changes into a gas at temperatures below its boiling point? Answer: Evaporation Question: What is the unit of measure for sound intensity? Answer: Decibel (dB) Question: What is the study of the Earth's atmosphere, weather, and climate? Answer: Meteorology Question: What is the part of a cell that controls its activities and contains genetic information? Answer: Nucleus Question: What is the process by which a gas changes into a liquid? Answer: Condensation Question: What is the force that opposes the motion of one surface past another? Answer: Friction Question: What is the unit of measure for electric resistance? Answer: Ohm Question: What is the process by which plants release water vapor into the atmosphere? Answer: Transpiration Question: What is the study of living organisms and their interactions with each other and their environment? Answer: Ecology Question: What is the phenomenon where light bends when passing from one medium to another at an angle? Answer: Refraction Question: What is the SI unit of energy? Answer: Joule Question: What is the densest planet in our solar system? Answer: Earth Question: What is the smallest bone in the human body? Answer: Stapes (in the middle ear) Question: What is the process by which a gas changes directly into a solid without passing through the liquid state? Answer: Deposition009
- Here's a high-level guide to help you understand the steps involved.In Tech Talk·September 19, 2023Here's a high-level guide to help you understand the steps involved. Please note that this is a general overview, and the exact steps might vary based on your specific environment and requirements. 1. Prerequisites: • Ensure you have the required hardware and software prerequisites for AutoSys R11.x.x or R12. • Obtain the installation media or download links for AutoSys, EEM, AE, and WCC. • Ensure you have the necessary licenses for the software. • Backup any existing AutoSys configurations if you're upgrading or migrating. 2. Install EEM (Embedded Entitlements Manager): EEM provides centralized user authentication and authorization. 1. Launch the EEM installer. 2. Follow the on-screen instructions, selecting the appropriate options for your environment. 3. Once installed, access the EEM management console to configure users, groups, and policies. 3. Install AutoSys AE (AutoSys Edition): 1. Launch the AutoSys AE installer. 2. During installation, you'll be prompted to specify the EEM server details. Provide the details of the EEM server you set up in the previous step. 3. Configure the AutoSys database. Depending on your setup, this could be an Oracle or SQL Server database. 4. Complete the installation by following the on-screen prompts. 4. Install WCC (Workload Control Center): 1. Launch the WCC installer. 2. During the installation, provide the details of the AutoSys AE server and the EEM server. 3. Complete the installation process. 5. Post-Installation Configuration: 1. EEM Configuration: Access the EEM console and define policies for AutoSys. This includes user roles, permissions, and other security settings. 2. AutoSys AE Configuration: • Configure job definitions, calendars, and other scheduling parameters. • Set up agents on target machines where jobs will run. • Configure communication between the AutoSys server and agents. 6. WCC Configuration: • Access the WCC console and connect it to the AutoSys AE server. • Configure dashboards, views, and other monitoring settings. 6. Testing: • Once everything is set up, it's crucial to test the entire setup. • Create test jobs in AutoSys and monitor them through WCC. • Test user permissions and roles through EEM to ensure security policies are correctly applied. 7. Documentation: • Document the entire installation and configuration process. This will be helpful for troubleshooting, future upgrades, or migrations. 8. Backup: • Regularly backup your AutoSys configurations, job definitions, and database to prevent data loss.005
bottom of page