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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

New Member

Can't figure how to configure a primary key for push datasets I created using the REST API

When testing out the REST API, I created a push dataset with a table called Contacts. This table was given two columns: "id" as an Int64 and "name" as a string. If I insert two rows with the same name value, I end up with one row containing an id value which is the sum of the value from both records. This appears to implicitly make the "name" column a primary key, with the implicit behavior of adding any numeric fields together. To make matters worse, I can't find any way to view the rows after they are inserted. Not from the API, the service, or the desktop app. How am I supposed to know if the ids are even being added together or if this is just how every visualization chooses to display the data? This black-box style of storage and configuration is quite unappealing compared to any SQL database experience.

I've spent a lot of time reading documentation for Power BI, including the information for push datasets (which is what I set the "defaultMode" to). I did not find anything mentioning this sort of behavior. I'm really hoping there is some sort of reference explaining how to control the primary key (if there is one?) and what happens for duplicate key inserts. For my use case, I need the primary key to be a number and, if possible, replace values if a row is inserted with duplicate key, not add them together.

New Member

Did you find any solution for the mentioned problem ? 

Helpful resources

Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.