fabric
26 TopicsCustom JSON theme not applying white fill to new shapes in Power BI
I’ve created a custom Power BI JSON theme where I set "shape": { "*": { "fill": "#FFFFFF" } } so that shapes should default to white. However, when I add new shapes after applying the theme, they don’t appear white they still use Power BI’s default fill. Existing shapes also keep their manual formatting. Can anyone explain how theme JSON settings for "shape" are applied to new visuals, and whether there’s a reliable way to force new shapes to respect the white fill defined in the theme?1.1KViews1like10CommentsSend Email using Python /PySpark Notebook
Hi Team, I would like to send email when my Notebook fails with any errors, which I am appending into "error_data" list; I want to do in Notebook and schedule that Notebook, so that if any error within Notebook execution, I will get an email Notification; I want to just do with Notebooks (Pipelines won't be required); and won't be needing any sender email; I just need to give receiver email. Any assistance on this will be highly helpful. Thanks in advance, AshwathSolved1.6KViews0likes4CommentsPower BI dynamic visualizations
We have a predefined list of columns (e.g., Col1 to Col50) from which users can select multiple columns. The report includes 10 table visualizations, and each one should display data from one of the selected columns. If the user selects more than 10 columns, only the first 10 selected columns should be used — each column should be mapped automatically to one of the 10 table visualizations. Example: If the user selects 15 columns out of the available 50, only the first 10 selected columns will be displayed across the 10 table visuals, with each table showing one selected column. Approach followed : Used parameter slicer to select the column list where user can select multiple columns. Able to get the first 10 selected columns using the measure but unable to map columns dynamically to the tabular visualizationsSolved2.5KViews0likes18CommentsUser Security Issues with Semantic Model From Mirrored Database
We are using Fabric Mirrored Databases. With the mirrored database, I have the SQL analytics endpoint. In the endpoint, I've created a view. I created a semantic model over the view, called DocuSignData. All of these artificats live in a workspace called analytics. I created a report over the DocuSignData semantics model, and published the report to a workspace called Division. My user has access to the Division workspace, has access to the report, and I gave him direct access to the DocuSignData semantics model in the Analytics workspace; he has Read, Build. He is able to open the report. But he is not able to see the data. For each visual, he sees Does anyone know what is causing this, and why we would be able to open the report, and not see the data? We were intentionally hoping to not give access to the mirrored database and SQL analytics endpoint - our users are not technical, and just want the report. Summary: Analytics Workspace: Mirrored Database, SQL Analytics Endpoint, View, Docusign Semantic Model Division Workspace: Report over Docusign Semantic Model Users has access to Docusign Semantic Model, Division Workspace, and DocuSign Report.Solved897Views0likes4CommentsIssues with Totals in Report Builder When Using DIVIDE and COUNTDISTINCT Measures
Hi, I've connected an RDL file in Report Builder to a semantic model developed in Microsoft Fabric. Basic measures like SUM work as expected. However, I'm encountering issues with more complex measures such as DIVIDE(Sum1, Sum2) and COUNTDISTINCT(ID), particularly in the total rows. When I don't apply a specific formula in the report, the total row displays First(measure) instead of recalculating the total as needed. For the DIVIDE issue, I understand that applying a formula directly in Report Builder can resolve it, which is acceptable. However, I have several complex measures to work with, like COUNTDISTINCT(ID), where retrieving all ID values would exceed my Fabric capacity, making it impractical to perform a distinct count directly in the report. Is there a feasible solution for this? Do you have any advice on handling such scenarios? Additionally, are there alternative tools for creating custom tables for export purposes, other than Power BI, which tends to slow down with complex measures and large datasets?Solved1.7KViews0likes3Comments2 Gateways, one Fabric warehouse
Hi Everyone, I have a problem with reports. From what I know, I can only use 1 on-premises gateway in 1 dataset in PBI. Understood. But having MS Fabric, can I pull the data from 2 different gateways to store it in Fabric data warehouse? In this DWH, I already have data from server A, but when trying to access server B, I get such error message: Can you please help me to solve this? From what I know, I need to have different gateways on these 2 servers, right? I need to combine data from server A and B, have relations set in PBI model and allow these reports to refresh automatically. Seems very strange for me that I cannot combine 2 different data sources into data warehouse, since it is one of the principal ideas of DWH - to combine data from different sources. Any ideas? What's important. The credentials I use for accessing this 2nd server via Fabric DataflowGen2 are the same as I use in MSSQL to pull data manually from server. And in MSSQL, it works just fine. Also, when creating PBI dataset that contains data only from this Gateway (server), I can set refresh as well. But I need to combine data from 2 gateways, and here's the problem. Many thanks in advance for any help!Solved1.8KViews0likes4Commentssynchronize current time on desktop and fabric
hello, i wanna synchronize current time on desktop and fabric 1. this is my power bi desktop 2. this is my power bi fabric dashboard before auto refresh by schaduler 3. this is my power bi fabric dashboard after auto refresh by schaduler 4. this is my schadule setting 5. this is my refresh history how to syncronize this ?? after i schaduler the data source to current time ???Solved995Views0likes4Commentson-premise Error for Redshift sources
Hello everyone, I have 2 VMs with on-premises clustered in Azure: these two gateways allow me to retrieve several data sources (SQL/Redshift/PostgreSQL). Since last week I can't retrieve Redshift sources: both gateways are partially online with a DLL error on GW number 2. I've updated, deleted and reinstalled the on-premise, tried to deactivate GW number 2 from the cluster but to no avail: the DLL indicated is indeed present in the right place on the VM. Azure Cloud 2: Received error payload from gateway service with ID 344420: ODBC: <ccon>ERROR [IM003] Specified driver could not be loaded due to system error 126: The specified module could not be found. (Simba Amazon Redshift ODBC Driver New, C:\Program Files\On-premises data gateway\m\ODBC Drivers\New\AmazonRedshift\AmazonRedshiftODBC_sb64.dll).</ccon>. The last solution would be to remove the GWs and reinstall an older version of on-premise, or to completely reinstall the VMs, but cel ame seems extreme. If you have any ideas, thank you.Solved1.2KViews0likes3Comments