Forum Discussion
Analyze in Excel
Hello,
2 days ago we had no problem, but now we can't access PBI data in Excel. All users are BPI Pro, settings in PBI Portal is OK.
6 Replies
- SkyterRegular Visitor
Hello,
2 days ago we had no problem, but now we can't access PBI data in Excel. All users are BPI Pro, settings in PBI Portal is OK.

- Hook3688New Member
I am experiencing this same issue. I am unable to connect to my reports or datasets through the Excel Power Bi tab.
- SkyterRegular Visitor
It seems to me that problem is in Excel 2016, cause i've just connected from one of my computers with Excel 2013.
- v-yulgu-msftMicrosoft Employee
Hi Skyter,
Based on my test, I could connect to Power BI service from Excel 2016 sucessfully.
As mentioned in error message, please check whether the dataset you choose exists and whether you have access to the selected dataset.
- Data that has been shared with you, but isn't directly visible to you in Power BI, is not available in Connect to Data.
- Datasets shared with people outside the specified group are not supported, and cannot be connected to.
- Reports or datasets that were shared with you cannot be connected to.
Reference: connect to Power BI data in Excel
Best regards,
Yuliana Gu- SkyterRegular Visitor
I'm sorry, but i've mentioned that:
- 3 days ago it was OK: It has DataModel, i'm administrator of this data and we've tried everything according to help
- I can access this data from one of my computers
So it looks like a bug in a system
- v-yulgu-msftMicrosoft Employee
Hi Skyter,
Please try to sign out and sign in again in Excel to see whether it resolves problem. Besides, if you click the "Analysize in Excel" on Power BI service, can you view dataset data successfully in Excel?
Regards,
Yuliana Gu