Forum Discussion
Using imported Excel files and direct query to SQL on same report.
Hi. I am trying to update an existing, working, Power BI report based on Excel files stored on prem. Because of the nature of the report this can be downloaded, data refreshed then republished when...
Hi Alex_Stennett ,
Could you please tell me the details of the error?
Whether this data source is the first or the second, it cannot avoid the need for a gateway and credentials if you want to refresh the reports.
If the error occured when you published, you can check this button turn on or off.
I think you can try to configure the gateway and credentials for the SQL data source.
Best Regards,
Community Support Team _Yinliw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.