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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

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

Feb2025 NL Carousel

Fabric Community Update - February 2025

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