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

View all the Fabric Data Days sessions on demand. View schedule

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
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

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.