Re: Get Power BI data and send in chat
1. Initialize variable. Using that later for the markdown image link.
![onedriveurl.png onedriveurl.png](/_api/msdyn_richtextfiles%282A63C285-1289-4042-8C81-F99D4DC5F847%29/msdyn_imageblob/$value?size=full)
2. This is part of the setup of the Export To File action. In this one you can configure a lot. And like mentioned earlier this action also depends on configuration and licensing on the Power BI side of things.
![exporttofile_powerbi.png exporttofile_powerbi.png](/_api/msdyn_richtextfiles%281BC7BC9A-90A4-4B23-8F34-EE911E48FB82%29/msdyn_imageblob/$value?size=full)
3. Create file action. This creates a file on OneDrive with the File Content of the previous action.
![createfile_powerbi.png createfile_powerbi.png](/_api/msdyn_richtextfiles%280298F7F2-9674-49B1-8579-CB0056D88CD7%29/msdyn_imageblob/$value?size=full)
4. Returning the link of the created OneDrive file in markdown format to the agent. I am using expression where I concatenate the OneDrive variable with the Name of the Create file action.
Which should be valid url for the chatbot to embed it as an image. I wrap it in a Image markdown tag ![Image](linktoimage)
concat(variables('OneDriveUrl'), outputs('Create_file')?['body/Name'])
![concat_onedrivefile.png concat_onedrivefile.png](/_api/msdyn_richtextfiles%287DCBC082-81EE-4723-B201-2E5B7A75E8B1%29/msdyn_imageblob/$value?size=full)