Power BI _ Data extraction from Website with Login and password

Surya Reddy 21 Reputation points
2021-11-02T10:01:20.153+00:00

Hi Team ,

Need help in how to extract the data from the secured website with login and password in Power BI?

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
35,879 questions
0 comments No comments
{count} votes

Accepted answer
  1. Ian Grandey 81 Reputation points
    2021-11-02T15:39:27.377+00:00

    Open Power BI Desktop and go to your data source settings. You should then be able to configure your connection to the data.

    However, options will change according to which type of data source you're using to "get data." Here's a view from the SQL Server I use, for work:
    145814-screenshot-2021-11-02-103411.png

    145806-screenshot-2021-11-02-103342.png

    For our SQL Server, we authenticate through windows. For SharePoint repositories (for example): We use our Microsoft account to authenticate. Previously, I was pulling data from a MongoDB ODBC--which required a username/password.

    Also--Make sure you've added the System DSN/User DSN in your ODBC Data Source Administrator (if this were the case).

    1 person found this answer helpful.
    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Dave Patrick 426K Reputation points MVP
    2021-11-02T12:53:00.72+00:00

    Power Bi is not currently supported here on Q&A. The product group for Power Bi actively monitors questions over at
    https://community.powerbi.com/

    --please don't forget to upvote and 145510-image.png if the reply is helpful--

    0 comments No comments