Forum Discussion
Unable to Manage Relationships
Resident RockstarHi amrtly
If the data is in Excel stored in Sharepoint you can connect to it by using the Web connector in Power BI.
Open Power BI Desktop , Click on Get Data , Select Web option , then enter the URL of the Excel file stored in your SharePoint library.
The Excel file Sharepoint URL will be something like "http://tenant.sharepoint.com/sites/sitename/library/folder/excefile.xlsx"
(You'll need to enterr the tenant name, sitename and any library and folder names etc.)
Make sure you use an Organizational Account option to authenticate. Other authentication mechanisms won't work while doing this. Sign in with your office 365 ID and password.
Once signed in, click on Connect and you will see tabs/sheets/tables from your Excel file. Select the tables you need and click on load.
Hope this helps
Stuart
yeah, but the problem is i cannot manage relationships between each table
- Burningsuit
If you connect to Excel files in this way, they will be brought in to Power BI desktop as tables into the Datamodel. If you have several tables or sheets in the Excel file, you will need to bring each table or sheet in as a table in Power BI. You will need to connect to web and bring in each individual table or sheet.
Once you have brought each table in to the Datamodel in Power BI you can then create the relationships between each table, by dragging between the related fields.
Hope this helps
Stuart