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.
Unfortunately, my issue has not yet resolved.
Hello tadeom0
Greeting for the day.
We are really sorry to hear that the issue has not been resolved, Please click on this Solved: Re: DM_GWPipeline_Gateway_MashupDataAccessError - Microsoft Fabric Community which is related to the issue which your have encountered and helps you solve the issue.
Additionally, please check the below link for your reference: Privacy Levels for Cloud Data Sources | Microsoft Power BI Blog | Microsoft Power BI
If this helps then please Accept it as a solution and dropping a "Kudos" so other members can find it more easily.
Hope this works for you!
Thanks.
I asked the admin of the sql server database and he mentioned that if I merge tables from sql server database to an excel file table, this will cause the error message when you refresh it in power bi service. Is any alternative that I can use to merge excel file tables to sql server database?
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.