Initialization of the data source failed using Power Bl Excel plug in
I created a dashboard in Power Bl which works well.
The disadvantage of this is that we also wanted to present the the information in a report format. To do this I used the Power Bl Excel plugin to connect to the report and built a Pivot table with the information required. This too works well.
I then shared this with the other users of the dashboard. This is where the challenge arises as they get the error from the title of this post. They have access to the data as they can use the dashboard it is based on but still get this message.
what am I doing wrong? Having excel spreadsheets that work Well with external data seems to be a real challenge!
Yeah sadly I still get the issue and still cannot figure out why. As far as I know if someone can see the dashboard then they should be able to see and update a spreadsheet that has data from that same dashboard exposed.