Forum Discussion

Arildsen's avatar
Arildsen
Frequent Visitor
3 years ago
Solved

Reports uploaded with terraform - not able to refresh azure sql data

Need some help with data connection in the Power Bi Service. Here's my scenario: I connect to my azure sql data with my sql admin user in Power Bi desktop. I create reports and everything is good. ...
Need Help
  • Arildsen's avatar
    Arildsen
    3 years ago

    Not sure why this is happening, but somewhere between my Power BI desktop via terraform and to the Power Bi service the credentials for my dataset "got lost" or just was not part of the upload of the pbix file. 

     

    The solution was just to manually use the POWER BI API with Postman and using the correct tokens patch the datasource with crendentials in the body payload.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Arildsen ,

 

To troubleshoot this issue, there are a few potential solutions to consider:

 

1.Check the Azure SQL database connection settings: Verify that the connection settings for the Azure SQL database in the report are correct and up-to-date. Check the server name, database name, and authentication method to ensure that they are accurate and match the credentials being used to connect to the database.

2.Check the Power BI data source settings: Verify that the data source settings in Power BI match the connection settings for the Azure SQL database. Ensure that the credentials being used to connect to the database are valid and have sufficient permissions to access the necessary data.

3.Check the Azure SQL firewall settings: Ensure that the IP address of the machine where the report is being generated is allowed through the Azure SQL firewall. If the IP address is not allowed, the database connection will fail, and the data cannot be refreshed.

4.Check the Terraform deployment settings: Verify that the deployment settings for Terraform are correct and up-to-date. Check the configuration files to ensure that the correct connection strings and credentials are being used to connect to the Azure SQL database.

5.Check the refresh settings in Power BI: Ensure that the data refresh settings in Power BI are configured correctly. 6.Check the frequency and time zone settings to ensure that the report is refreshing at the correct intervals and times.

 

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.