Forum Discussion

ritika_ritika's avatar
ritika_ritika
Regular Visitor
10 months ago
Solved

Unable to refresh Semantic Model for development workspace in Microsoft Fabric

After migrating from Power BI Service to Microsoft Fabric,, the reports in the environment are encountering technical errors when manually refreshing the semantic model. I have attached a screenshot ...
Need Help
  • rohit1991's avatar
    rohit1991
    10 months ago

    Hi ritika_ritika 

     

    If re-entering credentials didn’t work, the issue is likely with the SQL Server gateway connection. Could you please try below steps:

    1. Check Gateway – Go to Fabric Workspace › Manage Gateways and ensure a standard gateway is online and mapped to your SQL Server.

    2. Re-map Connection – In Semantic Model › Settings › Gateway connection, pick the correct gateway + data source and refresh.

    3. Network Access – Confirm SQL Server firewall allows Fabric/Gateway IPs (port 1433).

    4. Authentication – Make sure the auth method (Windows/Basic/OAuth) matches what’s used in Desktop.

    5. Re-publish if needed – Open the .pbix in Power BI Desktop >> refresh >> publish again to Fabric.

ritika_ritika's avatar
ritika_ritika
Regular Visitor
10 months ago

I have tried entering the credentials again, but no luck, data source is connected to sql server.

rohit1991's avatar
rohit1991
Icon for Super User rankSuper User
10 months ago

Hi ritika_ritika 

 

If re-entering credentials didn’t work, the issue is likely with the SQL Server gateway connection. Could you please try below steps:

  1. Check Gateway – Go to Fabric Workspace › Manage Gateways and ensure a standard gateway is online and mapped to your SQL Server.

  2. Re-map Connection – In Semantic Model › Settings › Gateway connection, pick the correct gateway + data source and refresh.

  3. Network Access – Confirm SQL Server firewall allows Fabric/Gateway IPs (port 1433).

  4. Authentication – Make sure the auth method (Windows/Basic/OAuth) matches what’s used in Desktop.

  5. Re-publish if needed – Open the .pbix in Power BI Desktop >> refresh >> publish again to Fabric.