Python and R in Power Bi service error

[lg01]

We are testing both Python and R in Power Bi. We created a sample with a simple scenario we run into all the time. After data in our table comes in, we add a calculated column in the query builder. This calculated column is somewhat complex and we handle it in a script. We just go to "Transform", pick the script type we need and add the script to the table like one more step. That works just fine in the desktop application. However, when we upload this file to the cloud service, and try to set up the refresh, it fails with an error:

Power Bi Data source error: Unable to refresh the model (id=710850) because it references an unsupported data source. 

What does that mean? I thought the R and Python services were supported in the cloud services? If the data refresh does not work, can we use it for other functions like create charts or do statistical calculations in the dashboard?

[lbendlin · Accepted solution]

R and Python in the Power BI Service mandate the use of a Personal Gateway.

[Brunner_BI · Accepted solution]

You can create Python and R visuals without any problems in the Power BI Service but as @lbendlin points out the data transformation (Power Query) part might require a gateway. 

Even though I am a little surprised that it would show the error message you are mentioning.

Can you check what you see in the settings of the semantic model in the Power BI Service?

[lbendlin · Accepted solution]

R and Python in the Power BI Service mandate the use of a Personal Gateway.