Forum Discussion

jacklamlan's avatar
jacklamlan
Frequent Visitor
3 years ago
Solved

Using email as a database in shared report

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

Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    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

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    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's avatar
      jacklamlan
      Frequent Visitor
      3 years ago

      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.