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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Anonymous
Not applicable

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:

.

$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?

.
 
4 REPLIES 4
v-diye-msft
Community Support
Community Support

Hi @Anonymous 

 

Sorry I can't reproduce your scenario on my side, I'd like to suggest you raising it to support team for better advice:

https://powerbi.microsoft.com/en-us/support/ 

Support Ticket.gif

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.
Anonymous
Not applicable

Hi @v-diye-msft .

 

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

Hi @Anonymous 

 

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

 

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.
Anonymous
Not applicable

Hi @v-diye-msft .

 

I'm not Pro user. Maybe this is the reason because I can't see this options for create ticket.

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.