cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
admin_xlsior
Post Prodigy
Post Prodigy

Deploy Power BI failed from F&O

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,

 

1 ACCEPTED SOLUTION
v-diye-msft
Community Support
Community Support

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.

 

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.

View solution in original post

6 REPLIES 6
YumnaAsim
New Member

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.

Hi @YumnaAsim ,

 

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.

 

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...

YumnaAsim_0-1606469780468.png

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.

 

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

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
Community Support
Community Support

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.

 

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.

View solution in original post

Helpful resources

Announcements
MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Top Solution Authors
Top Kudoed Authors