Are calculated columns supported by Push datasets?

[Anonymous]

Hi All,

I am experimenting with Push datasets to understand the limitations before I can make a proposal to my customer.

When I see the definition of a Column object in Microsoft's site., I do not see a support for calculated columns.

Models produced by SSDT have calculated columns as follows:

          {
            "type": "calculated",
            "name": "ParticipantId",
            "dataType": "string",
            "isDataTypeInferred": true,
            "expression": "LOOKUPVALUE(vwParticipants[Id], vwParticipants[AccessToken], vwBodyCompositionSummary[UserDeviceAccessToken])"
          }

Does that mean push datasets do not support calculated columns?

Thanks,

Sau

[v-xiaoyan-msft]

Hi @Anonymous ,

Does the replies above solve your problem? If it has been solved, please mark the correct reply as the standard answer to help the other members find it more quickly.Thanks in advance for your kind cooperation!

Hope it helps,

Community Support Team _ Caitlyn

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[bcdobbs · Accepted solution]

Hi Sau, 

In the strictest sense no a push dataset doesn't support a calculated column.

However you populate data into it using the REST API's Add Row end point. You can therefore just use a "normal" column, calcualte the values for it in your system and push values as part of the row to the model.

SQLBI have some useful stuff, try this as  a starting point:
Creating real-time dashboards in Power BI with push datasets - SQLBI

[Anonymous]

Hi @bcdobbs ,

I am looking at the section "Populating a push dataset" in the article from SQLBI.

If I understand correctly, they appear to be running a DAX query to create the data which is then fed via PUSH rest api.

Will this work on Professional license?

Thanks,

Sau

[bcdobbs]

Yes they are simulating pushing data from a query but I think you can "push" any data you want at the REST API.

My understanding is the Rest API is available to pro licences (Rest API Cost? - Microsoft Power BI Community).