Forum Discussion

trevb's avatar
trevb
Advocate II
9 years ago

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...
Need Help
trevb's avatar
trevb
Advocate II
9 years ago

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.

v-micsh-msft's avatar
v-micsh-msft
Microsoft Employee
9 years ago

OK.

If any further help needed, please post back.

Regards

  • trevb's avatar
    trevb
    Advocate II
    9 years ago

    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.

    • v-micsh-msft's avatar
      v-micsh-msft
      Microsoft Employee
      9 years ago

      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