Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Secheduled Refresh Issue - Cannot Set Credentials for Dataset

Hi,   I'm trying to setup a Scheduled Refresh for a dataset (small dataset - about 50MB) in the Power BI Service which points to Azure SQL Data Warehouse.  I'm entering the Authentication Mode as "...
Need Help
v-caliao-msft's avatar
v-caliao-msft
Microsoft Employee
9 years ago

Anonymous,

 

Can you reproduce this issue? If you can, please capture the following logs while recreating the issue. 

 

Fiddler Trace

============

  1. Install Fiddler from http://www.telerik.com/download/fiddler/fiddler4 if not already done
  2. Launch fiddler, then click Tools > Fiddler Options
  3. Click the ‘HTTPS’ tab.
  4. Verify the options are set as shown in this screenshot:

111.jpg

 

5. If fiddler prompts you to trust their root certificates, then click ‘Yes’.

6. Then navigate to repro the problem while fiddler is capturing traffic.

7. After the trace is captured, go to File > uncheck box next to Capture Traffic

8. File > Save > All Sessions and post it here.

 

Regards,

Charlie Liao

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi, can I send it to someone?  I'd rather not post it here.  Thanks

     

    Andy

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      I can enter the credential for the SQL Server if I remove the "secure" part of the connection string, e.g:

       

      mydatabaseserver.database.secure.windows.net will NOT allow me enter credentials on the PBI Service - just hangs

       

      mydatabaseserver.database.windows.net WILL allow me enter credentials on the PBI Service