04-20-2017 03:05 PM
Hi - In the New Navigation that will go GA in May, workbooks brought into Power BI with the OneDrive / Excel online experience are not appearing in the Workbooks in the New Navigation.
Since this will move out of preview in May, we will experience loss of functionality if this is not resolved.
Am I missing a setting or something?
Solved! Go to Solution.
04-20-2017 03:30 PM
I now imported an Excel file from OneDrive as well as uploaded the file to both "My Workspace" as well as a Group Workspace with no issues.
Could it possibly be in your first image it was shared to you, so when you look under the new Navigation Experience you do not have access to a file that has been shared with you?
04-20-2017 03:55 PM
I tried it too and it works fine.
The issue is that the other workbook was shared with you (you can see the share symbol on the side).
Search in "Shared with me" and you will be able to find it.
Power BI, Microsoft.
04-20-2017 07:38 PM
Thank you for the replies. In my scenario, yes, the Workbook is an Excel Power Pivot file (that we are desparately waiting for the GA of the new Matrix visualization in order to replace with a pbix) that is shared via a Content Pack in a users (biadmin) "My Workspace"
This content pack is then consumed via the Get Data Experience in the Group Workspace Inside Sales Team Group. With the new navigation, this shared workbook is not available while the user is in the Group Workspace Inside Sales Team Group. As per Ajay's suggestions, when Shared with Me is selected, it takes the user back to their own My Workspace. and since the workbook is shared in OneDrive with the Group, the user does not see it.
We don't want to make 20 copies of this file for each Workspace that consumes it, hence the reason we shared it via a Content Pack. (see screenshot below) And yes, the Group has permission to the file on OneDrive (which is why they are able to consume it in the Old Navigation experience)
04-20-2017 07:42 PM
Another option might be if rather you use the new Power BI Service Dataset?
If you do it in this manner you only have to author the Dataset Once, then publish it into a Group Workspace. Once that is done people can then connect to it from their own Power BI Desktop's and create the reports that they require and then publish as they require?
04-24-2017 09:49 AM
However, It still means that the previous exprience of being able to view Excel Online Workbooks shared via a Content Pack is no longer true.
I am trying to confirm that we will have to redeploy because the current approach will no longer work in the New Navigation Experience.
04-24-2017 12:13 PM
Can you email me at email@example.com...
1. Do you see it in the content list?
2. Do you see it when you opt-out of the new navigation?
If this is a bug, we will address it pretty quick.
Power BI, Microsoft.
04-24-2017 03:22 PM
Correct - If opted out of the new Navigation, the workbook appears. If you refer to the screenshots in the Original Post, first picture uses Green boxes and are for the old Navigation and the second picture uses Red for the New Navigation. The Excel Workbook appears as the "shared" icon in the first picture and is missing from the Workbooks section of the New Navigation.
Not entirely helpful if anyone is reg-green colorblind in retrospect.
We have users using the preview and we have to tell them to turn off the preview in order to access the Excel Workbook they have been using for over a year.
05-07-2017 04:45 AM
Hi. I'm using a workbook held in my (personal) OneDrive account. My personal account has the same name/email as my business account (which only has an Outlook subscription). The workbook still shows under the Dataset section. Does it need to come from the business account to show as a workbook in PowerBI?