Using email as a database in shared report

[jacklamlan]

Hello,

I currently have a report that uses my Exchange email inbox as a database. This report scrapes my email and gives insights to the finish time of a certain process that is sent via email every day.

Currently, when others try to view this report in Power BI desktop, they cannot refresh the database to see new information. I have two questions:

1. If I publish this report, will others be able to view and refresh the report?

2. Is there a way for me to give other accounts permission to view my email or this database in Power BI desktop?

Below is the error that shows up when someone else tries accessing this email database:

Thanks

[amitchandak · Accepted solution]

@jacklamlan , Once you publish, Go to dataset settings. I think there you can give your own credentials in datasource credentials and get data refreshed based on that

[jacklamlan]

Great, thanks.

Is there any way that I can add my credentials to allow someone to work on this report in Power BI desktop before it is published? Currently other users cannot connect to the db, therefore cannot do any work on the report in PowerQuery editor.