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!
