Forum Discussion
Data Source Error when refreshing data in Power BI Service
Hi tadeom0,
Thank you for your follow-up.
To address the issue you're encountering, you can consider merging the tables directly in SQL Server instead of doing it in Power BI. This can be achieved by creating a new table in SQL Server that combines the data from both the SQL Server database and the Excel file. This approach can help avoid the refresh error in Power BI Service.If you need further assistance or have any more questions, feel free to ask. If this solution works for you, please mark it as accepted and give it a "Kudos" so other members can benefit from it.
Thank you.
Hi tadeom0,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
Unfortunately, my issue has not yet resolved.