Share
Report
3Hi All
The outcome of this is a Customizable table in my PowerBI model and a PowerApp in the same model that is basically a question and answer with a button so that you can query your data via ChatGPT.
The user types the question, and the button then sends the data table (as a json) and question to ChatGPT via PowerAutomate and OpenAI API. This works perfectly when testing in the PowerApp workspace.
However I get a JSON parsing error ("JSON parsing error, expected 'number' but got 'string'.")when I do the exact same from PowerBI and the data contains a blank
The PowerApp simply converts the table data from the "powerbiintgration.data" to a JSON using the JSON function in powerapps. e.g SET(MyJSONVariable, JSON(powerbiintgration.data)). This can then be sent to OpenAI API via powerautomate
Some notes:
When including multiple measure and dimensions there will always be blanks and converting "0" is not practical.
The column names are dynamic, and change based on user selection
I have noticed the powerbi intgration does not pick up columns that where not originally included when creating or updating the app. This is also a issue.
Any help on this would be appreciated.
All responses (
Answers (
