Menu

3 bugs that only showed up once real users touched my AI dashboard generator
📰

3 bugs that only showed up once real users touched my AI dashboard generator

DEV Community: python·Syed Faaris Razi·about 10 hours ago
#lj6PznuY
#devtopython#devto#dev#real#error
Long article (433 words) — no AI summary yet.
Reading 0:00
15s threshold

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.

1. A syntactically invalid M-query that only fails once Power BI actually parses it

Every embedded-table dashboard I generated failed to open, with a cryptic M Engine error: Token ',' expected . The root cause: inside a type table [Col = type text, ...] ascription, you're already in type-expression context -- so writing type text again is a syntax error. It has to be bare text . Int64.Type 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).

2.…

Continue reading — create a free account

Join HashtagPLUS to read full articles, follow hashtags, vote, and join the conversation.