topic Problematic Functions causing problems in PBI Report Server in Report Server

Problematic Functions causing problems in PBI Report Server

Anonymous — Thu, 02 Dec 2021 15:34:15 GMT

Hello Power BI Community,

Is there some lists/summary of functions, which might cause problems for report created in Desktop Version when it is uploaded to Power BI Report Server?

or any your ideas of such functions?

thanks in advance for any suggestions!

Re: Problematic Functions causing problems in PBI Report Server

d_gosbell — Thu, 02 Dec 2021 23:58:19 GMT

As long as you use the version of Power BI Desktop optimized for Report Server that matches the same version of Report Server that you have deployed you should never have any DAX that will work in Desktop, but not on the server.

But you should never use the standard version of Desktop to try and publish to report server as there could be all sorts of things that could break and the files may not even upload at all.