Now Available in Community - New TechTalk Videos for 2020
2020 release wave 1 Discover the latest updates and new features to Dynamics 365 planned through September 2020
Release overview guides and videos Release Plan | Preview 2020 Release Wave 1 Timeline
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Upcoming TechTalks
I got this situation whereby I've changed AXResource-PBIX file to a new one -> Build application -> Released. The newer PBIX file also uploaded into my LCS. Deploy Power BI files. But during open the Workspace in F&O, it looks like they still using the older PBIX.
To be more detail, like folwing:
1. Have an AX Resource element, using file TestA.pbix.
2. Build and Release the code
3. Upload TestA.pbix to LCS
4. From F&O > System Administration > Deploy Power BI, look for the Power BI model uploaded in LCS -> Deploy Power BI (succeeded)
5. Look at the Workspace, it is running.
6. Go back to Visual Studio, change AX Resource element, this time using TestB.pbix
7. Build and Release the code
8. Upload TestB.pbix tp LCS
9. From F&O, Deploy again, but this time for the latest uploaded TestB in LCS Power BI model list. (succeeded)
10. Look at the Workspace, it throw error
11. In the Event Viewer, Application and Service logs > Microsoft > Dynamics > AX-PowerBI > Operational
There are 2 line record that I recognized referring to that action :
- Task Category : PowerBIReportExecutionTask -> Message : Start running PowerBI report hosted in PowerBI.com, but the report name is still refer to TestA
- Task Category : PowerBIReportExecutionTask - > Message : Stop running PowerBI report, report name is TestA
I have reset IIS after step 9, but it seems it is not refresh. This is still in UAT environment, btw,
Anyone experienced this before, and what else do I need to do ?
What error message did you see in step 10?
I just put in the other post.
Check records in table 'PBIEMBEDDEDREPORTCONFIG' and see what you have got regarding resource name and associated report name.
I happened to find one discussion about this. And it suggested to delete all. so I already delete all from that table.
Strange is, it is still empty until now. Shouldn't it re-populate if we run the report again inside F&O ?
Yeah it should repopulate once you open the report but if it is not populating that means issue is something else. Can you verify once if used resource referring correct PBIX.
Yes, it is confirmed, since in that F&O workspace, if I open Options menu, there is a "Select <pbix name>" with the new name (means the changes was successfully deployed) but the report loaded is still the old one by referring to Even Viewer.
Another thing which make it confirmed, because it is still UAT environment, so I can take a look at the installation folder, then go to <model folder> / AxResources, and I can find the latest pbix over there.
Anywhere else I need to check ? or the last effort is just to restart the machine it self ? This has not been done since we still using it for other department.
Ok. Yeah check that and try refreshing cache as well.
Thanks Ajit, will do it once it is permitted. Btw, "refreshing cache", in where? browser ? if somewhere else, probably I would like to know to command as well, since I only know to "delete" browser cache only, and I already did.
There is a cache management under system parameters, you can clear cache from there.
Never mind that's custom feature :)
I'm sorry, but I cannot find that cache management under system parameters.
That is from System Administration > Setup > System parameters, right?
the one with 4 Tabpage: General, Data connection, Help, Legal and Privacy.
In the action pane, I have Save button and the usual Options.
Try through URL - xxxprod.operations.dynamics.com/
Update with your instance url.
If we delete record in table PBIEMBEDDEDREPORTCONFIG in AXDB, when or what process actually the system re-populate the table again ?
I have 2 cases, one in my 1Box which only 1 specific record I deleted and the other is my UAT which I delete all the records, but it never get re-populated.
I have this issue whereby the my custom workspace keep call old report which I already change the report name in Visual studio and Build successfully. I have also ran this job : xxxprod.operations.dynamics.com/, but still the problem persist. In my 1Box it is said now "PowerBIEntityNotFound"
Which if in Microsoft documents also tells it is because Report Id false
If I check my event viewer after the error, it has the log saying the old report. I've ran IISRESET also restart my Dynamics365 batch job service just to make sure.
Not sure, but most likely something in package deployment process populates that table. So try to apply your latest deployable package to the UAT system.
Just wondering, should I dare to ask what will happen in my 1box then :)
Try to build and sync your model where the PBIX is.
Business Applications communities