Forum Discussion

manoplaeli's avatar
manoplaeli
Helper II
1 year ago
Solved

Can not refresh data from MS Fabric

I am building Power BI report base on Data Warehouse (connect to SQL end point as import mode) in MS Fabric. I was able to connect to data under the warehouse and refresh from Power BI desktop. When ...
Need Help
  • Wikkleyn_81's avatar
    Wikkleyn_81
    1 year ago

    Hi manoplaeli You need to create a Cloud connection for the Model. 

    Go to the Settings of your Semantic Model. Expand Gateway and Cloud Connection.
    Under     Cloud Connections click on the dropdown at Maps To and select create a connection

    Follow the steps to create the connection and click create. 

     

    That will take you back to teh settings of the Semantic Model. Make sure this new connection is selected and click Apply

     

KPR106's avatar
KPR106
Regular Visitor
1 year ago

Hi manoplaeli ,
 Please try the below steps to resolve the issue:

  1. Check Authentication and Permissions: 

         Ensure you're using Import Mode (not DirectQuery). 

         Verify that your Power BI Service account has sufficient permissions to configure data source credentials. 

  2. Configure a Data Gateway : 

        If you're using an on-premises data source (SQL Server), ensure a Power BI Gateway is installed and           configured. 

       Go to Power BI Service > Settings > Gateway and add the data source if needed. 

  3. Update Data Source Credentials: 

         Go to Settings > Data Source Credentials in the Power BI Service. 

         If credentials are grayed out, ensure you have the correct permissions and re-enter authentication       details SQL credentials etc.

4. Re-publish and Test Refresh: 

     After making changes, re-publish the report to Power BI Service. 

     Trigger a manual refresh to see if the credentials are properly configured. 

 

If this is helpful for you, please let me know.

Thank You.