Template app not refreshing from Power BI Service

[Shreyas1902]

We want to make a Power BI template app consisting of reports for Microsoft Project Online. We are taking Project Online Base URL as a parameter from the end user so that users can refresh the reports on their data. While testing we noticed that if there are additional columns in the user's table (apart from those present while making the app), the refresh fails in Power BI Service. We are getting the following error -

Something went Wrong.

The last refresh attempt failed because of an internal service error. This is usually a transient issue

Is there a way to get around this ? Do I need to filter out the additional columns and keep only those which are originally present while making the app ? Is this how template apps work ?

Thanks

[v-eqin-msft]

Hi @Shreyas1902 ,

As the official document said:

If you added a new query parameter to the updated dataset that requires users input - you must check the required check box. This will prompt the installer with the connection string after updating the app.

Reference: 

Power BI template apps limitations

Template App: Sample data refresh

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

[Shreyas1902]

Eyelyn - thanks for the reply! We have created this app many times, and we always check the "required" box for url_parameter. Unfortunately the above error continues to happen. Do you have other suggestions to fix it?