1,227
Hi,
Start from 8.0 PU 15, we no longer can install power bi desktop in development environment.
Does anyone try to access UAT axdw database with Power BI Desktop? Is that possible?
I had tried using the method to login axdb database to login axdw, but no luck. It kept saying wrong password for sqladmin and axdwadmin.
Any advice is much appreciated.
Thanks.
Regards,
Teh
- Sign into VM
- Download Power BI Desktop
- Open Power BI Desktop
- Home -> Get Data -> SQL Server Database
- Server: servernameFromLCS.database.windows.net
- Database: databaseNameFromLCS
- Select Direct Query or Import (Whichever is your preference)
- Click OK
- Select Database on left side of pop up screen
- User name: axdwadmin
- Password: PasswordFromLCS
- Click Connect
- Power BI Navigator should open showing data from AXDW Database.
*******************************************************************
**********If connecting to a Power BI Report********
-Open Power BI Report in VM
- Close any pop up windows
- File -> Options and settings -> Data Source Settings
- Click on "Change Sources"
- Server: servernameFromLCS.database.windows.net
- Database: databaseNameFromLCS
- Click OK
- Select Edit Permissions -> Edit
- Select Database on left side of pop up screen
- User name: axdwadmin
- Password: PasswordFromLCS
- Click Save
- Click OK -> Close
- Apply changes should appear on the top of your report. Click on this and the report should connect to the AXDW Database.
Try connecting to the database using Power BI Desktop with the credentials. servername.database.windows.net , databasename(Make sure you do not enter (AXDW) , axdwadin and password. I can connect using Power BI Desktop but I can't access the db with SQL Management Studio. You must be using Power BI Desktop from within the UAT VM.
I am trying to access the AxDW from within the remote desktop. I am able to connect to Remote desktop but there I am unable to connect using the Axdwadmin credentials in SQL
Where are you connecting from? My understanding is that you can't access the UAT database from outside of the UAT VMs.
The LCS setting for access only enables RDP connections to the UAT server. It doesn't enable SQL access to the UAT database.
Hi
I am unable to understand where I might have gone wrong. I have tried accessing the RDP of the BI server.
I used the server name as provided on LCS added .database.windows.net at the end
and the user name and password for axdwadmin from LCS.
Yes you can connect to AXDW Database for UAT. Make sure you are putting in the correct server and database from LCS. Also you need to add .database.windows.net to the end of your server name. I am connected using the axdwadmin credentials.
Yes, I know cannot connect from outside. I was in the UAT VM itself and tried to use the same way to connect to axdb from UAT, but it seem cannot work.
In newer verison, we no longer can install power bi desktop in dev environment. So was trying to see any other method to develop embedded Power BI report with UAT environment instead of hosted locally or in Azure.
#1
André Arnaud de Cal...
291,661
Super User 2024 Season 2
#2
Martin Dráb
230,379
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
