Forum Discussion

FrustratedPM's avatar
FrustratedPM
New Member
8 years ago

Why is "Get Data" so difficult?

So here's my exprience:    We have data on prem, and in cloud. No problem understanding that.  This tool is also about data. Big data. Lots of data. So it's automatically going to be about thousan...
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
8 years ago

Sounds like you aren't using the right connector. If you use the SharePoint Online list connector, you should definitely be offered to use OAuth. Perhaps you are using the SharePoint (on-premises) connector by mistake?

 

If you have a specific issue or question we are happy to help. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

 

If you just want to complain, well, you probably won't get much help. Please vent to co-workers instead. That's not really the purpose of this forum.

102938974756545's avatar
102938974756545
Regular Visitor
8 years ago

OK, let's try again. 

 

PowerBI Desktop > Home > Get Data > More...

 

In the serch box that pops up, typing "SharePoint" gives three options:

1. SharePoint Folder

2. SharePoint Online List

3. SharePoint List

 

Choose SharePoint Online List

 

I now have to provide credentials. 3 Options. 

1. Anonymous - Access is forbidden

2. Windows - Current or alternate credentials

    Current - Access is forbidden

    Alternate -  Access is forbidden 

     (and that's trying with both my domain and my office 365 login)

3. Microsoft Account

     Sign in > "Sorry you don't have access"

 

 

So where exactly is the OAuth option supposed to be accessed from? 

 

(And if I use other methods to access it, like the web page, or a database connection, I have full access no problem)