Forum Discussion
Error Automatic Refresh in Power BI Service
Hello, I am having trouble generating the automatic refresh of my dashboard in Power BI from the Power BI Service. When I update my report from Power BI Desktop it refreshes fine. I have...
Hi Harvey85 ,
Which connection mode are you connecting to the sql data source?
Once the report is published to the service, you need to configure the gateway, and the appropriate connectors, and make sure the credential information is configured correctly.
For more details, you can read below document:
DirectQuery in Power BI - Power BI | Microsoft Learn
Configure scheduled refresh - Power BI | Microsoft Learn
Best Regards,
Adamk Kong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello Anonymous, I'm connecting to a SQL Server database by "Import" method. Would it be okay?
And also I'm extracting data from an Excel file