Issue with Dataset Refresh in Workspace (Azure Synapse)

[Anonymous]

Hi Team,

I have built the data model, created reports, and successfully published them to the workspace. The primary only one data source for the report is Azure Synapse. Below are the steps I followed to retrieve data from Azure Synapse:

1. Get Data → Azure Synapse
2. Entered the server name and logged in using service account credentials.

To enable dataset refresh in the workspace, I requested the Admin team to create a data gateway for Azure Synapse, for which I shared the following details:

• Server Name: servername.sql.azuresynapse.net
• User ID: Service Account Name
• Password: ******

After the data gateway was created and added to the dataset, the refresh is failing, and I am encountering the following error:

Error: _https://[Server and folder details]/Dimension_Table/delta_log
Issue: The delta log is missing in the folder path.

However, when loading and refreshing the dataset in Power BI Desktop, it works fine. The issue arises only when refreshing in the Power BI workspace.

Could you please assist in troubleshooting this issue? Let me know if you need any additional details.

[Anonymous]

Hi @Anonymous 
Hi 
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.

[Anonymous]

Hi @Anonymous 
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.

[Anonymous]

Hi @Anonymous 

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.

[Anonymous · Accepted solution]

Hi @Anonymous 
Thank you for reaching out microsoft fabric community forum.

It seems like you're encountering a common issue with dataset refresh in Power BI when using Azure Synapse as the data source. Here are a few steps and considerations that might help resolve the issue:

• Make sure that the workspace has the necessary permissions to access the dataset. This includes verifying that the login information is accurate and up-to-date
• Double-check the configuration of the data gateway. Make sure that the server name, user ID, and password are correctly entered and that the gateway is properly set up to connect to Azure Synapse
• The error message indicates that the delta log is missing in the folder path. This could be due to incorrect folder paths or missing files. Verify that the folder paths are correct and that all necessary files are present
•  If you're using basic authentication, ensure that the login information is secure and that the data sources have the necessary permissions. If possible, consider using OAuth2 for better security and reliability
• Sometimes, issues can arise due to the configuration of the workspace itself. Make sure that the workspace is set up correctly and that there are no conflicting settings that might be causing the refresh to fail
• check  both Power BI Desktop and the Power BI service are up-to-date. Sometimes, updates can resolve underlying issues that might be causing the refresh to fail.
  
  

If you need any further assistance or have any questions, please feel free to reach  us.

If this solution helps, please consider giving us Kudos and accepting it as the solution so that it may assist other members in the community.

Thank you.