question

SuryaReddy-0939 avatar image
0 Votes"
SuryaReddy-0939 asked igrandey answered

Power BI _ Data extraction from Website with Login and password

Hi Team ,

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

power-query-not-supported
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

igrandey avatar image
1 Vote"
igrandey answered

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).


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

DSPatrick avatar image
0 Votes"
DSPatrick answered

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--




5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.