Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi
looking for help, as im having a bit of challenge with importing an excel from sharepoint online to power bi.
ive recently upgraded from power bi to pro/premium.
i can see the file in question via the "get data" approach.
however, when i edit the query to try and manipulate the data i cant see to find the relevant fields to access the tables in questions?
when ive looked at the help tutorials they infer there should be a heading called "name" but as you can see its not listed?
any ideas?
out of interest i can do the whole process without issue if i use a local file.
Solved! Go to Solution.
Hi Lydia
its ok i realised i was using the wrong connect approach. i was using the sharepoint option when the web one seems to be the one that does the job.
all working now
thanks
peter
@pcray,
Do you use Web entry in Power BI Desktop to connect to SharePoint Online Excel? Could you please describe more details about what specific field you are finding?
When I connect to SharePoint Online Excel in Power BI Desktop, it brings all the data and fields of the excel table.
Regards,
Lydia
Hi Lydia
its ok i realised i was using the wrong connect approach. i was using the sharepoint option when the web one seems to be the one that does the job.
all working now
thanks
peter