Deploy Power BI failed from F&O

[admin_xlsior]

Has someone Deploy Power BI from Dynamics 365 F&O ?

If it is failed, can we check somewhere what causing it ? system log ? event viewer?

Many thanks in advance,

[Anonymous]

I faced the same issue, I was trying to deploy the power bi file on testing env (D365 FO) and deployment was getting failed. The issue was we created a PowerBI report on the latest PowerBI desktop version which has some preview feature and not supports FinOps. So we uninstall the latest PowerBI desktop and install earlier versions of Power BI Desktop (prior to September 2020 update) and create the report again. Uploaded the report on LCS and deploy it (D365 FO). It works.

[admin_xlsior]

Hi @Anonymous ,

I was once heard about this also, is it true ? and which earlier version are you using ? any before September 2020 ? 

Because I was heard it should be March 2020. 

And what Preview feature actually causing this ? is there any formal information from Microsoft it self ? Since I need to give some 'valid' reason for my management.

Thanks in advance.

[Anonymous]

Yes, it is true, uninstalling the latest version and installing the older version help to deploy the report on my end. You can see the older version in the image below, download link: https://docs.microsoft.com/en-us/power-bi/fundamentals/desktop-latest-update-archive#august-2020-upd...

I am not sure about the preview feature. I couldn't find any information from Microsoft. We contacted Microsoft support and they suggested us to try with the older version (prior to September) and it worked for us.

[admin_xlsior]

Hi,

I just downgrade to Sep 2020 edition. And it already hit me with some limitation of Direct Query.

In the latest version, I can add Custom column for just some string manipulation  like "Text.Start([Month longname],3) & Text.End([Month longname],5))" without the warning it is not supported, but in August 2020 does. 

Have you experience the same, or I just missed out some setting ?

Thanks

[Anonymous]

I used the August version of PowerBI and created a new report on this version. My report has columns (added a new column) and measures. I don't face any errors/warnings and haven't made any changes in settings.

Additionally, I was trying to use the DAX function i.e. format() and it gives me an error that can't use DAX in Direct Query mode so I removed it.

[v-diye-msft · Accepted solution]

Hi @admin_xlsior 

You might refer to these articles for the detailed procedures:

http://www.everythingdynamicsaxbi.com/2017/01/23/how-to-configure-power-bi-for-dynamics-365-operatio... 

https://www.powerobjects.com/blog/2018/06/25/how-to-integrate-power-bi-with-dynamics-365-for-finance... 

https://blogs.msdn.microsoft.com/dynamicsaxbi/2017/07/29/deploy-power-bi-embedded-service-for-dynami... 

Please use fiddler to capture the whole process and trace log. You can use fiddler following the guide in this video: https://www.youtube.com/watch?v=8Fs3CVAw9lk.