<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom" xmlns:dc="http://purl.org/dc/elements/1.1/">
  <channel>
    <title>DEV Community: Syed Faaris Razi</title>
    <description>The latest articles on DEV Community by Syed Faaris Razi (@faarisrazi).</description>
    <link>https://dev.to/faarisrazi</link>
    <image>
      <url>https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F4233091%2F6c0c3df4-fdcb-46e7-8c5e-3e3c7264365a.png</url>
      <title>DEV Community: Syed Faaris Razi</title>
      <link>https://dev.to/faarisrazi</link>
    </image>
    <atom:link rel="self" type="application/rss+xml" href="https://dev.to/feed/faarisrazi"/>
    <language>en</language>
    <item>
      <title>3 bugs that only showed up once real users touched my AI dashboard generator</title>
      <dc:creator>Syed Faaris Razi</dc:creator>
      <pubDate>Fri, 20 Nov 2026 17:49:42 +0000</pubDate>
      <link>https://dev.to/faarisrazi/3-bugs-that-only-showed-up-once-real-users-touched-my-ai-dashboard-generator-bpj</link>
      <guid>https://dev.to/faarisrazi/3-bugs-that-only-showed-up-once-real-users-touched-my-ai-dashboard-generator-bpj</guid>
      <description>&lt;p&gt;I spent the last few weeks building DashPrompts, a tool that turns a spreadsheet + a plain-English prompt into a real Power BI project (.pbip) that you can play with on desktop. Most of the interesting bugs weren't in the AI layer -- but were in the compiler that turns a "shopping list" of charts and measures into the actual TMDL/report.json files Power BI Desktop expects. 3 of them stood out.&lt;/p&gt;

&lt;h2&gt;
  
  
  1. A syntactically invalid M-query that only fails once Power BI actually parses it
&lt;/h2&gt;

&lt;p&gt;Every embedded-table dashboard I generated failed to open, with a cryptic &lt;code&gt;M Engine error: Token ',' expected&lt;/code&gt;. The root cause: inside a &lt;code&gt;type table [Col = type text, ...]&lt;/code&gt; ascription, you're already in type-expression context -- so writing &lt;code&gt;type text&lt;/code&gt; again is a syntax error. It has to be bare &lt;code&gt;text&lt;/code&gt;. &lt;code&gt;Int64.Type&lt;/code&gt; was unaffected, which is why the error always pointed at the first text column and sent me down the wrong path for a while (I initially suspected scientific-notation number formatting instead).&lt;/p&gt;

&lt;h2&gt;
  
  
  2. A measure property that quietly requires a specific Analysis Services compatibility level
&lt;/h2&gt;

&lt;p&gt;I wanted a stacked bar chart's segments to self-label with a dynamic, SELECTEDVALUE-based format string (&lt;code&gt;formatStringDefinition&lt;/code&gt; in TMDL). It kept failing with "Invalid indentation," which sent me chasing whitespace bugs for two rounds. The real blocker: that property requires AS compatibility level 1601, and my template had it hardcoded at 1550 from months earlier. The error message had nothing to do with the actual cause.&lt;/p&gt;

&lt;h2&gt;
  
  
  3. A password-reset flow that pointed every real user at localhost
&lt;/h2&gt;

&lt;p&gt;Not Power BI bug, but a consequential one: Supabase's Auth "Site URL" defaults to &lt;a href="http://localhost:3000" rel="noopener noreferrer"&gt;http://localhost:3000&lt;/a&gt; and nobody had ever changed it after going live. The actual password-reset code in the frontend was correct -- it was passing the real production URL as redirectTo -- but Supabase silently falls back to the Site URL whenever the requested redirect isn't on an explicit allow-list. Every single real user hitting "forgot password" got bounced to a dead localhost link. Fixed by setting the real Site URL and adding the production domain to the Redirect URLs allow-list -- a two-minute fix once found, but a very real "check your platform defaults, not just your own code" lesson.&lt;/p&gt;

&lt;p&gt;If you're building anything that compiles into a rigid file format (TMDL, OOXML, whatever), the lesson that sticks&lt;br&gt;
&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2F08rp44kdlrj514dv55z4.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2F08rp44kdlrj514dv55z4.png" alt=" " width="800" height="471"&gt;&lt;/a&gt;: trust the real engine's error over your own first guess at the cause, and verify behavior against the actual schema/docs rather than pattern-matching from a similar-looking property.&lt;/p&gt;

&lt;p&gt;Building this in public at dashprompts.com if anyone's curious about the rest of it.&lt;/p&gt;

</description>
      <category>powerbi</category>
      <category>buildinpublic</category>
      <category>ai</category>
      <category>python</category>
    </item>
  </channel>
</rss>
