How to make a DAX calculation return BLANK rows
I'm working on a Power Bi template for my company. Since we are a global comapny i added Time Zone tables that help the end-user filter the visual for their Time Zone. Now I'm trying to create a DAX measure that will get the values in a DATE/TIME type column and sum the given UTC Offset in Hours, however I'm having a hard time when there's no value in a give row, DAX will just either not return the rows with blank or return the offset. What I'm trying to achieve is a function that will ignore the blank values and still return them, and when there is a value actually SUM the End Time UTC with the Offset. Note: [Current UTC Offset] is a measure that returns a decimal number from -12 to +12 How can i achieve this?
Query: Power BI Custom Visual API Block – GPT/Gemini Integration Issue
I’m working on integrating ChatGPT or Google Gemini into Power BI using a custom visual to enable interactive AI responses directly from the report, based on the dataset contents. Everything works fine when I test the API in Postman, but Power BI blocks the API call from the custom visual due to security restrictions, most likely related to Content Security Policy (CSP) or cross-origin (CORS) issues. I’ve Tried So Far Built a custom visual in Power BI using React and TypeScript Integrated OpenAI/Gemini API logic inside the visual Created a proxy API server to forward the API requests Used tunneling tools like: Localtunnel ngrok Cloudflare Tunnel But unfortunately, the API calls are still being blocked when the custom visual is rendered inside Power BI Desktop I Need Help With How can I successfully connect Power BI custom visual to OpenAI/Gemini API through a proxy or tunnel? Is there a recommended tunneling or reverse proxy approach that works with Power BI visuals? Any other approaches to solve the problem. Please share your thoughts. Any guidance or step-by-step solution would be greatly appreciated! Thanks!
Error related to data refresh in file: tmmdmodeltm.cpp
Hi, I have developed my report locally and refreshed data with no errors and also no errors has speen spotted anywhere in the report locally. Now im publishing the report to server. Tried to refresh the data and got an error related to data refresh in server. Has anyone faced similar problem? "An error has occurred. Several errors occured during data refresh. Please try again later or contact your administrator. [0] -1056964608: An unexpected error occurred (file 'tmmdmodeltm.cpp', line 7611, function 'MDModelTM::IsAttributeHierarchyQueryable'). [1] -1055129594: The current operation was cancelled because another operation in the transaction failed." We are using version: Version1.19.8779.19175(January 2024). Could someone help me out, what this file does or what this error-message refers to? Thanks!
Need Month-Year Granularity in Free Gantt Visual for Power BI
Hi Team, I’m working on a project timeline visualization in Power BI. My goal is to show projects across months (MMM-YYYY) with managers clearly visible. Current challenges: The Microsoft Gantt visual only supports duration units like Days, Hours, Minutes, Seconds. There’s no option to format the timeline axis as MMM-YYYY or set granularity to Month. Most advanced Gantt visuals (MAQ, PowerGraph, xViz) require paid subscriptions, which is a blocker for many users. What I need: A free Gantt visual that supports Month-Year granularity and custom date formatting. Ability to group by Manager and show project bars spanning start and end dates. Why this matters: Monthly timelines are critical for project planning and reporting. Many organizations rely on Power BI’s free visuals for accessibility and cost control. Could Microsoft consider adding these features to the default Gantt visual or provide a free alternative? Project Manager / Lead Lead PM Region 2nd PM Client Name UPA account No. Project Name (free text) Project/Displacement Overview (free text) Project Type Customer Sector LDA customer? Project Region Scope Annual Recurring Revenue (GBP) Once off Cost Planned Project Start Date Original project End Date Revised Project end date (if applicable) Project Phase Phase Status Supporting comments for Project phase (Free text) % Complete (manual) RAG ID Project Ref Manager 1 APAC PeerPM 1 Client 1 ACC-1000 Project 1 [redacted] Strategic - Execution FX Yes [EMEA] 06-03-2025 19-12-2025 Execution Technical issue [redacted] 46% Red 1 PRJ-1 Manager 2 APAC PeerPM 2 Client 2 ACC-1001 Project 2 [redacted] New Business IB Yes [APAC] 26-02-2025 03-05-2025 Execution On track [redacted] 43% Amber 2 PRJ-2 Manager 3 AMERS PeerPM 3 Client 3 ACC-1002 Project 3 [redacted] Displacement FX No [AMERS] 04-04-2025 24-08-2025 Execution Client Delay [redacted] 93% Red 3 PRJ-3 Manager 4 APAC PeerPM 4 Client 4 ACC-1003 Project 4 [redacted] Displacement IB No [APAC] 31-03-2025 31-03-2026 Execution On track [redacted] 73% Green 4 PRJ-4 Manager 5 AMERS PeerPM 5 Client 5 ACC-1004 Project 5 [redacted] New Business FX Yes [AMERS] 17-06-2025 13-12-2025 Execution Technical issue [redacted] 95% Amber 5 PRJ-5 Manager 6 EMEA PeerPM 6 Client 6 ACC-1005 Project 6 [redacted] New Business Cross Asset No [APAC] 20-07-2025 15-07-2026 Execution Technical issue [redacted] 20% Red 6 PRJ-6 Manager 7 APAC PeerPM 7 Client 7 ACC-1006 Project 7 [redacted] New Business Equities Yes [AMERS] 05-10-2025 23-05-2026 Execution Client Delay [redacted] 51% Red 7 PRJ-7 Manager 8 APAC PeerPM 8 Client 8 ACC-1007 Project 8 [redacted] Displacement FX No [EMEA] 30-03-2025 19-06-2025 Execution Technical issue [redacted] 38% Amber 8 PRJ-8 Manager 9 AMERS PeerPM 9 Client 9 ACC-1008 Project 9 [redacted] Displacement FX No [AMERS] 10-09-2025 26-07-2026 Execution Technical issue [redacted] 37% Red 9 PRJ-9 Manager 10 AMERS PeerPM 10 Client 10 ACC-1009 Project 10 [redacted] Displacement Equities Yes [EMEA] 18-09-2025 10-03-2026 Execution Technical issue [redacted] 88% Amber 10 PRJ-10 Manager 11 EMEA PeerPM 11 Client 11 ACC-1010 Project 11 [redacted] New Business FX Yes [AMERS] 09-09-2025 28-02-2026 Execution Client Delay [redacted] 56% Red 11 PRJ-11 Manager 12 AMERS PeerPM 12 Client 12 ACC-1011 Project 12 [redacted] New Business Cross Asset No [AMERS] 26-11-2025 28-01-2026 Execution Client Delay [redacted] 48% Amber 12 PRJ-12 Manager 13 APAC PeerPM 13 Client 13 ACC-1012 Project 13 [redacted] New Business Cross Asset Yes [EMEA] 01-01-2025 15-11-2025 Execution Client Delay [redacted] 93% Green 13 PRJ-13 Manager 14 APAC PeerPM 14 Client 14 ACC-1013 Project 14 [redacted] New Business IB No [AMERS] 09-12-2025 14-07-2026 Execution Client Delay [redacted] 80% Red 14 PRJ-14 Manager 15 APAC PeerPM 15 Client 15 ACC-1014 Project 15 [redacted] New Business Cross Asset No [APAC] 02-04-2025 29-06-2025 Execution Technical issue [redacted] 31% Green 15 PRJ-15
