Forecloud Technologies

 Introduction: You can now add your Power BI report to Dynamics CRM form and also add filters to the report easily with Power BI embedder tool of XRM Toolbox. Explanation: Download Power BI Embedder in XRM Toolbox and connect to your organization Chose the D365 CRM Entity, Form, Tab, Section where you want to embed the Report. In formatting change the rowspan to ensure the report fits on the page as needed. In Power BI Config add the Group ID, Report ID and Page you will find this on the report URL in Power BI https://app.powerbi.com/groups/ 98765ty7-nju7-567y-vft5-12345678yytr /reports/ 4fb4555-9d54-yyff-9987-f49999999999 / ReportSection5afdbb2222228c4221 Group ID- Yellow Report ID- Red Page - Green click on the filter checkbox to add filter PBI table - Name of table in Power BI that contains the field to be filtered  PBI Column - name of field to be filtered as per Power BI CDS Field- select the CDS field from dropdown, this will be the equal to value of filter. Note that PBI Table a

Introduction:  In this blog we will understand the action "Export to File from PowerBI report". Power BI has options to Export the Report in PPT or PDF format, however if you need the Report to be uploaded to SharePoint or send as email using a flow, you can use the  Export to File from PowerBI report action in power automate. Explanation: The Export To File for Power BI Reports has below parameters- Workspace- In dropdown you will see the workspace options, if you are the owner of report or if report is shared with you, you will see the report in "My workspace". Report- Select the report from the dropdown, it will show all reports that you have access to in the workspace Export Format can be PDF, PPTX or PNG You can add further details like Bookmark, locale, etc. Another main parameter is Filter- if the main report is not filtered but you need the exported one to be based on a filter you can add the filter as Table/fieldname eq 'value' Please Note that the