Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Create "none" dataset with Json post method

Hi.

I am using Json to add data to a table in real time. Json's appearance is what Power Bi gives me by default:

.

$endpoint = "https://api.powerbi.com/beta/2260c04a-d2b6-41e3-83e4-edccf923a8d8/datasets/8dfbb27f-7d74-4d0c-8baf-0e133aaa0477/rows?key=Lb372AAdeSm1j3w0BFJhy7iceBtSPIPkbw4FBhi3rS7nzzpdw2"
$payload = @{
"idAgente" =98.6
"idCampanya" =98.6
"idFinal" =98.6
}
Invoke-RestMethod -Method Post -Uri "$endpoint" -Body (ConvertTo-Json @($payload))

.
By default, the table has the "defaultRetentionPolicy" mode, but I need the table to use "NO retention policy" to be able to store as much data as possible (up to 5,000,000 according to the specification), because I need to store at least 2 years of data.

.

How can I do that?
How can I have a "NO retention policy" table in real time?
Are the limits different with the professional subscription?

.
 
Need Help

4 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi v-diye-msft .

       

      I don't have this "Continue to support ticket" button.

      • v-diye-msft's avatar
        v-diye-msft
        Icon for Community Support rankCommunity Support
        6 years ago

        Hi Anonymous 

         

        You should text your question first and click research, then the documentation lists appeared with "Continue to support ticket".

         

Related content