Refresh fails for import mode with Fabric DWH

[42cdx]

Hi,

can anybody help me with this refresh problem:

I have a PBI report with import mode. The only source is a Fabric DWH. I publish the report and semantic model to the same workspace where the DWH is located.

When I try to refresh the semantic model in PBI Service, I become an error message:
"Scheduled refresh is disabled because at least one data source is missing credentials. To start the refresh again, go to this dataset's settings page and enter credentials for all data sources. "

(In PBI Desktop the refresh works!)

When I try to configure the source connection with my personal account that doesn't work (authentication fails, but I am logged into the workspace with the exact same credentials).

Do I need to create a connection via a service principal?? Thought it would work without any further configuration because everything is located in the same workspace...

Thanks in advance!

[v-sdhruv]

Hi @Myriam ,
Good to know that your issue was resolved.
Can you please mark the response that helped you reached the solution?

This will help the other community members to reach the solution quickly.
Thank You

[v-sdhruv]

Hi @Myriam ,
Good to know that your issue was resolved.
Can you please mark the response that helped you reached the solution?

This will help the other community members to reach the solution quickly.
Thank you for reaching out on Community Forum.

[Myriam]

Thanks @ibarrau and @v-sdhruv !! This helped a lot and I now got it up and running 😊😊😊

[v-sdhruv]

Hi @42cdx ,

As correctly pointed out by @ibarrau , you need to create a cloud connection and then map your dataset to use new data source.
You can follow these steps:

1. Go to Power BI Service->Workspace-> Data Sources.

2. Click "New connection".

3. Choose Microsoft Fabric / OneLake as your source.

4. Provide the DWH details and authenticate using:

   • Your personal account or

   • A Service Principal (recommended for automated refreshes).

5. Map the Connection->, map your dataset to use this new data source

6. Go to the Dataset settings-> Data source credentials.

7. You should now see your cloud connection as a selectable source.

8. Select it and save

Refer-

https://learn.microsoft.com/en-us/power-bi/connect-data/service-create-share-cloud-data-sources

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ibarrau]

Hi. If I remember correctly, Fabric lakehouse and warehouse is requiring to add them as cloud shareable sources in order to let them use credentials. You should create the cloud connection and map it in the picture you are showing. You can check this articles explaining how to do it.

- https://learn.microsoft.com/en-us/power-bi/connect-data/service-connect-cloud-data-sources

- https://learn.microsoft.com/en-us/power-bi/connect-data/service-create-share-cloud-data-sources

I'm pretty sure once you create the connection and map it, it will let you refresh.

I hope that helps