Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
turbofred69
Frequent Visitor

Blank value sent by Power BI to the flow triggered from the report

Hi 

 

I want to trigger a flow from a pPowerBI report to store records with incorrect / blank data in a Sharepoint list

 

Using the assistant, it is working fine at the beginning and the flow trigger receives the expected data

 

{
  "type""object",
  "properties": {
    "rows": {
      "type""array",
      "items": {
        "type""object",
        "properties": {
          "entity": {
            "type""object",
            "properties": {
              "Power BI values": {
                "type""array",
                "items": {
                  "type""object",
                  "properties": {
                    "Part ID A": {
                      "title""Power BI data Part ID A",
                      "type""string"
                    },
                    "Part ID B": {
                      "title""Power BI data Part ID B",
                      "type""string"
                    },
                    "HSCode": {
                      "title""Power BI data HSCode",
                      "type""string"
                    }
                  },
                  "required": []
                }
              }
            },
            "required": [
              "Power BI values"
            ]
          }
        },
        "required": [
          "entity"
        ]
      }
    }
  },
  "required": [
    "rows"
  ]
}
 
But after some changes and refinements of the flow (done though teh Power BI screen), no more data are passed and the schema looks corrupted.
{
  "type""object",
  "properties": {},
  "required": []
}
I can't find any way to reinitlize it. Can anymone give me some hint?
 
BR/
Frederic
 
0 REPLIES 0

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors