top of page
Type
Category
110 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
- Any one have dax pattern collection notes ?In Ask QuestionsOctober 16, 20231. 1. Time Patterns: • Time Intelligence: • Year-To-Date (YTD): TOTALYTD(SUM([Sales]), 'DateTable[Date]') • Month-To-Date (MTD): TOTALMTD(SUM([Sales]), 'DateTable[Date]') • Quarter-To-Date (QTD): TOTALQTD(SUM([Sales]), 'DateTable[Date]') • Same Period Last Year: CALCULATE(SUM([Sales]), SAMEPERIODLASTYEAR('DateTable[Date]')) • Moving Averages: • 3-Month Moving Average: AVERAGEX(DATESINPERIOD('DateTable[Date]', LASTDATE('DateTable[Date]'), -3, MONTH), [Total Sales]) • Related Table Filtering: • Use RELATEDTABLE to get a table related to the current table. • Example: CALCULATE(SUM([Sales]), RELATEDTABLE('RelatedSalesTable')) • Top N Filtering: • Retrieve the top 5 products by sales: TOPN(5, 'Products', [Total Sales]) • Dynamic Segmentation: • Categorize sales into segments: SWITCH(TRUE(), [Total Sales] < 1000, "Low", [Total Sales] < 5000, "Medium", "High") • Hierarchical Navigation: • Use PATH to get the hierarchy path: PATH([EmployeeID], [ManagerID]) • Path Functions: • Retrieve the first item in the path: PATHITEM([EmployeePath], 1) • Ranking: • Rank products by sales: RANKX(ALL('Products'), [Total Sales]) • Percentile: • Calculate the 90th percentile: PERCENTILEX.INC('Table', [Sales], 0.9) • Standard Deviation: • STDEVX.P('Table', [Sales]) • Rounding: • Round to 2 decimal places: ROUND([Value], 2) • Trigonometry: • Calculate the sine of an angle: SIN([Angle]) • String Manipulation: • Concatenate strings: & operator or CONCATENATE function. • Search: • Check if a string contains another: SEARCH("text", [Column], , , -1) > 0 • Related Information: • Retrieve related data: RELATED('RelatedTable[Column]') • Missing Information: • Check for blanks: ISBLANK([Column]) • What-If Analysis: • Use slicers and parameters in Power BI to change input values and see the effect on results. • Forecasting: • Use the built-in forecasting tools in Power BI. • Dynamic Metrics: • Use slicers or drop-downs to let users select which metric to display. • Error Handling: • Use ISERROR to check for errors and IFERROR to handle them. • Debugging: • Use VAR to store intermediate calculations and inspect them. • Performance: • Minimize the use of functions that force row-wise computations, like EARLIER.00
- how to get this ' floor(weekend (today())))' in DAXIn Ask QuestionsSeptember 29, 2023WeekendCheck = VAR CurrentDay = WEEKDAY(TODAY(), 2) -- This starts the week on Monday (1) and ends on Sunday (7) RETURN IF(CurrentDay = 6 || CurrentDay = 7, 1, 0) -- Return 1 for Saturday or Sunday, otherwise 0 This formula will return 1 if today is a weekend (Saturday or Sunday) and 0 otherwise.00
- One quick question please : Do we need to install any gateway to connect post GRE SQL database to connect to Azure.In Ask QuestionsOctober 27, 2023To connect a PostgreSQL database to Microsoft Azure, you do not necessarily need to install a gateway. However, the specific approach depends on the nature of your integration. If you're trying to migrate a PostgreSQL database to Azure Database for PostgreSQL, you can use tools like the Azure Database Migration Service or pg_dump and pg_restore commands. If you want to connect a PostgreSQL database to an Azure service, like Azure Logic Apps or Azure Functions, you can use standard PostgreSQL connection strings and drivers. In any case, you should ensure that your PostgreSQL database is accessible from the internet and that the necessary firewall rules and security configurations are in place to allow connections from Azure.00
- please help with the formula of “% of Parent Row Total”for Multi-level Hierarchy in BI, like we do have in Excel Pivot.In Ask QuestionsOctober 14, 2023Here's a step-by-step guide to create a "% of Parent Row Total" measure for a multi-level hierarchy: 1. Sample Data: Assuming you have a table named Sales with the following columns: • Category • SubCategory • SalesAmount 2. Create a Hierarchy: In the Fields pane, drag the Category field above the SubCategory field to create a hierarchy. Name this hierarchy as CategoryHierarchy. 3. Create the Measure: To calculate the "% of Parent Row Total", you'll need to determine the context of the current row and then calculate the percentage based on the parent's total. Here's a DAX formula to achieve this: % of Parent Row Total = VAR CurrentLevel = SELECTEDVALUE('Sales'[CategoryHierarchy], BLANK()) VAR ParentTotal = SWITCH(TRUE(), ISBLANK(CurrentLevel), SUM('Sales'[SalesAmount]), // If top level, take total sales VALUES('Sales'[Category]), // If subcategory level, take category total BLANK() // Default ) RETURN DIVIDE(SUM('Sales'[SalesAmount]), ParentTotal) 4. Use the Measure in a Matrix Visualization: • Drag the CategoryHierarchy to the Rows shelf of a Matrix visualization. • Drag the SalesAmount and % of Parent Row Total measures to the Values shelf.00
- C Macro with a function errors out: expression cannot be used as a functionIn Ask QuestionsSeptember 29, 2023The issue you're encountering is due to the fact that macros are expanded by the preprocessor before the actual compilation takes place. When you use a function inside a macro, the function is not yet defined at the time of macro expansion, leading to the error you're seeing. To fix this, you should ensure that the necessary function prototypes are available before the macro is expanded. In this case, you're using the strrchr function, which is declared in the string.h header. You should include this header before defining the macro. Here's the corrected code: #include #include // Define a helper macro to get the file name from __FILE__ #define FILENAME_ONLY(file) (strrchr(file, '/') ? strrchr(file, '/') + 1 : file) // Use the helper macro to create MYFILENAME #define MYFILENAME FILENAME_ONLY(__FILE__) // Create __MYFILE__ macro #define __MYFILE__ "[" MYFILENAME "]" int main() { printf("%s\n", __MYFILE__); return 0; } By including string.h at the top, you ensure that the strrchr function prototype is available when the macro is expanded. This should resolve the error you're seeing.00
- I want to ask for a project recommendation related to data science/ML/AI/Cloud related for a portfolio made?In Ask QuestionsOctober 19, 2023Data Science project 1. Customer Segmentation: Objective: Use clustering algorithms to segment customers based on their purchasing behavior. Data: Customer purchase history, demographic information, etc. Tools: Python, pandas, scikit-learn, matplotlib, seaborn. 2. Time Series Forecasting for Stock Prices: Objective: Predict future stock prices using time series analysis. Data: Historical stock price data. Tools: Python, pandas, NumPy, scikit-learn, matplotlib, seaborn. Machine Learning project 1. Sentiment Analysis for Product Reviews: Objective: Analyze customer reviews to determine the sentiment towards a product. Data: Customer reviews from websites like Amazon, Yelp, etc. Tools: Python, pandas, scikit-learn, NLTK, matplotlib, seaborn. 2. Image Recognition with Neural Networks: Objective: Build a neural network to recognize images. Data: Image datasets like CIFAR-10, MNIST, etc. Tools: Python, TensorFlow, Keras, OpenCV. Artificial Intelligence project 1. Chatbot Development: Objective: Develop a chatbot that can handle specific tasks or answer questions. Data: Conversational data, domain-specific data. Tools: Python, Rasa, TensorFlow, Dialogflow. 2. Game AI Development: Objective: Develop an AI that can play and possibly master a specific game. Data: Game data, player data. Tools: Python, Unity, TensorFlow, PyTorch. Cloud project 1. Serverless Image Processing Pipeline: Objective: Create a serverless pipeline to process images uploaded to a cloud storage bucket. Data: Images. Tools: AWS Lambda, Google Cloud Functions, Azure Functions, Python, OpenCV. 2. Cloud-based Machine Learning Model Deployment: Objective: Deploy a machine learning model in the cloud and expose it as a REST API. Data: Any data relevant to the machine learning model. Tools: AWS SageMaker, Google AI Platform, Azure Machine Learning, Docker, Python, Flask.00
- One quick question please : Do we need to install any gateway to connect post GRE SQL database to connect to Azure.In Ask QuestionsOctober 28, 2023Thankyou for the support.i will go through the steps that was provided.0
- Can you please tell what is the difference between Paginated report visual in power bi visual pane and Paginated reports build through ..In Ask QuestionsOctober 19, 2023Paginated Report Visual in Power BI Visual Pane • Ease of Use: Easy to integrate within a Power BI report, providing a seamless experience. • Purpose: Primarily used to add paginated report-like visuals to your interactive Power BI reports. • Interactivity: Works within the Power BI ecosystem, allowing you to have interactive dashboards along with paginated visuals. • Data Source: Relies on the same dataset as the Power BI report. • Design Flexibility: Limited compared to Report Builder; you're restricted to the visual's capabilities within the Power BI interface. • Sharing and Deployment: Shares the same sharing and deployment options as Power BI reports. Paginated Reports Built through Report Builder • Ease of Use: Requires a separate tool (Report Builder) for creating reports, and then uploading to the Power BI service. • Purpose: Designed for scenarios where you need traditional, pixel-perfect, paginated reports that can be printed or shared as PDFs. • Interactivity: Limited interactivity compared to Power BI reports; mainly used for static, printable reports. • Data Source: Can connect to a variety of data sources, including those not available in Power BI. • Design Flexibility: Offers more design flexibility, with detailed control over the layout, formatting, and grouping of data. • Sharing and Deployment: Can be shared and deployed through the Power BI service, but also through other means like email subscriptions.00
- Are you getting Microsoft mashup engine1 error, odata version 3 and 4 error, error 404 not foundIn Tech TalkJuly 20, 2023Yes, that's correct. To connect to files stored in SharePoint using the "SharePoint Folder" connector in Power BI, you need to provide the correct URL of the SharePoint document library that contains the files you want to access. Here's how you can do it: 1. Go to the SharePoint Document Library: • In your SharePoint site, navigate to the document library that contains the files you want to connect to in Power BI. 1. Copy the URL: • Copy the URL from the address bar of your web browser. The URL should look something like this: https://your-sharepoint-site.sharepoint.com/sites/YourSiteName/Shared%20Documents/YourDocumentLibrary/ 1. Go to Power BI Desktop: • Open Power BI Desktop. 1. Get Data from SharePoint Folder: • Go to the "Home" tab and click on "Get Data." • Choose "SharePoint Folder" from the list of data sources. 1. Enter the SharePoint URL: • In the "From SharePoint Folder" dialog, paste the URL you copied from your SharePoint document library into the "Folder Path" field. • Click "OK." 1. Connect to Files and Folders: • Power BI will connect to the SharePoint document library and display the files and folders it contains in the Navigator window. 1. Choose Files to Load: • In the Navigator, select the files you want to load into Power BI by checking the corresponding checkboxes. You can also choose to load all files in the document library. 1. Click "Load": • Once you've selected the files you want to load, click on "Load" to load the data into your Power BI report.0
- I am trying to install FullStory to record sessions on SF. The script is uploaded as a static resource into SFIn Ask QuestionsSeptember 29, 2023import { LightningElement } from 'lwc'; import fsScript from "@salesforce/resourceUrl/local-fullstory"; import { loadStyle, loadScript } from "lightning/platformResourceLoader"; export default class FullStoryTest extends LightningElement { connectedCallback() { console.log("in connect " + fsScript); loadScript(this, fsScript) .then(() => { console.log("Loaded"); window.FS = FS; // Attach FS to the window object console.log("FS obj " + FS); }).catch((err) => console.log(err)); } } By attaching FS to the window object, you're making it globally accessible. After loading the component, you should be able to access the FS object from the browser console using window.FS or simply FS.00
bottom of page