Forum Discussion

KeyDiego's avatar
KeyDiego
Frequent Visitor
6 years ago

Excel export

 Hi everybody,   I am exporting the data in Excel using the "Analyze in Excel" function, as you can see in the photo below:     Then I am creting some graph and chart and I would like to s...
Data Modeling
Excel Export
Sharing
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
6 years ago

First off, "Analyze in Excel"  is different from Export. It creates a cached connection to the Power BI dataset that users with Build permissions can refresh.

 

Are you running on Power BI Pro or Power BI Premium?  If you are not on Premium then all users of your Excel file need a PRO license if they want to REFRESH the connection.  But if you refresh the connection and then send the Excel file around the non- Pro users can also see the data (just not refresh it)

KeyDiego's avatar
KeyDiego
Frequent Visitor
5 years ago

Thank you Ibendlin, but I have tried also today to share an Excel file with an user (who has a Power BI Pro License) and he is still not able to refresh the data. I have also set him as "Owner" of the dataset and of the Working Space but nothing. Still the same error.

 

Do you have any suggestion about it?

 

Many Thanks

Diego