Forum Discussion
Initialization of the data source failed using Power Bl Excel plug in
Hi trevb,
Are you using the Analyze in Excel, or the Power BI publisher for Excel?
If this is Analyze in Excel, how did you share the dashboard with the others?
“
In order to share your workbook with other Power BI users, you must share the dataset (the workbook) by doing one of the following:
- Share the Power BI dashboard that hosts a pinned element from your Power BI report with the user
- Share a content pack that contains the dataset with the user (I prefer this option)
- Add the user with whom you want to share to the group that owns the dataset
”
Reference: Analyze in Excel
Also check the troubleshooting page and see if it would help:
Troubleshooting Analyze in Excel
Besides, check to see the Excel version, some folks also shared that different version Excel (from the one which editing the ODC file ) would cause the error you mentioned when open the ODC file.
For Power BI publisher, we could connect to the related dataset or report, create the Pivot table and then PIN the Pivot table into a preferred dashboard.
Regards
Hi There,
I've loaded the powerbi excel stuff and then used the option connect to data whereupon I have connected to the report data.
The users have access to the data as they can all use the dashboard. That was the reason I used this route to provide the data for the spreadsheet.
The different version thing could be the answer here. I am not sure what version the guys that tried to open this are using. I will find out.
OK.
If any further help needed, please post back.
Regards
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.
Hi trevb,
Apologize for the late response.
I suspect the issue here should be related with the ODC file, with the Analyze in Excel function.
Pllease take a try to switch to Power Bi publisher for Excel, and verify if issue insists. Check the article I shared in my earlier post for the details.
Regards