Create a report from a workbook

Question

Hi,&nbsp;There's a team site on sharepoint where we have an Excel Workbook. I opened it in a desktop application to use the publish to Power Bi feature.&nbsp;When I log in to my power bi account I can see the workbook I published from excel is in My Workspace under "Workbooks". I'm not sure how I can create a report out of it. I don't see that workbook when I try to get the data from Power Bi Desktop (PowerPlatform=&gt;Power Bi datasets). I'd like to create a report based on it and publish it to our sharepoint site.&nbsp;Assuming the above is possible, am I correct assuming that the edits done to the original workbook on the sharepoint site will be reflected in the report (assuming I'll schedule refresh as I'd do with other datasets. Are scheduled refreshes possible on a workbook)?&nbsp;Thank you

venal · Accepted Answer

Anonymous&nbsp;Please refer the below links.&nbsp;https://docs.microsoft.com/en-us/power-bi/service-excel-workbook-fileshttps://docs.microsoft.com/en-us/power-bi/desktop-import-excel-workbooks&nbsp;Sharepoint Excelhttps://docs.microsoft.com/en-us/power-bi/desktop-use-onedrive-business-links&nbsp;If this post helps, then please consider Accept it as the solution to help the other members find it moreIf this post was helpful may I ask you to mark it as solution and give it some kudos?(please click on Thumb symbol)&nbsp;&nbsp;

Forum Discussion

Create a report from a workbook

1 Reply

Related content

Fabric Create report API

Workbook into Lakehouse

Creating thin reports

Suggestion for creating editable Word reports (not using report builder)

Error on create report