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,

Does your dataset contain Azure SQL database data source and Excel file data source?  Or you combine Azure data source, on-premises SQL database and Excel file in a single dataset?


What error message do you get when adding Excel file within on-premises gateway? You can follow the guide in this similar thread to add Excel data source.


Regards,

Lydia