Forum Discussion
Adding to a dataset in PowerBI service
Hello - some advice, please. I have a dataset in PowerBI service that uses two tables from a SharePoint file. I would like to add a third table to create visualisations in the existing report associated with this dataset. Is that possible? I don't want to have to download the report and make changes in Desktop unless absolutely necessary, as I would then need to publish it again and provide colleagues from across the business with a new link (not an ideal seamless experience). Any advice would be appreciated. Thank you!
3 Replies
- AnonymousNot applicable
Hi KateToddNatArc ,
It would be great if you could provide more information about this issue.
Please correct me if I have misunderstood your needs.
Your report now exists in two data sources, one for Power BI Dataset and one for SharePoint, does your third table refer to adding to either one of them or adding a new one?Best Regards,
Community Support Team _ Caitlyn - KateToddNatArcNew Member
Hi Caitlyn,
Thanks for your reply. My report in PowerBI service is fed by an Excel workbook in my organisation's Sharepoint. I have since added another sheet to the Excel workbook and would like to add it to my report. Is this possible in the service or only in desktop?
Thanks for your help,
Kate
- AnonymousNot applicable
Hi KateToddNatArc ,
Please try to down load the Pbix files and open it in Power BI Desktop.
After you add the third table ,then republish it.
Best Regards,
Community Support Team _ Caitlyn