Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Trying to get Power BI to work with an Excel Data Source

Hi all,   I'm scratching my head over this because I feel like it shouldn't be that difficult.  But it has been. I've got a report that works fine on my computer and connects to Azure and to datab...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Microsoft Support helped me find the answer.  It's actually pretty easy.  Just need to go to Edit Queries > Data Source Settings and you can get to all the remembered credentials. 

    Why though would this be hidden under the Edit Queries button is beyond me.  It really needs to be displayed somewhere a little more obvious.  Or maybe shown as an option under Get Data as well...

     

    But in here I can edit the settings and clear ones that I don't want applied. 

     

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Anonymous,

It seems that you are connecting to csv file that locates on SharePoint online site. Please enter the following url instead in web connector and use organizational account. There is an example for your reference.

https:// your root site url/Shared%20Documents/your folder name/yourcsvname.csv



Regards.
Lydia

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thanks Anonymous (Lydia),

 

But unfortunately for me, the Access Web Content page (second screen shot that you sent) no longer comes up, so I don't have the choice for organizational account any longer.  I just get the error message Access to the resource is forbidden.  I'm thinking that there is a bug because I believe I entered the information in once, but I chose wrong on that Access Web Content page.  But now I can't get back to it. 

 

Anyways, I'm going to put the data into a database instead of an Excel file.  This should fix the issue for me, but it won't resolve the bug.

Thanks!

Drew