Unable to refresh semantic model in Power BI Service

[Nnnn0015]

Hi Everyone,

I am new to Power BI and we are creating POC. We have created a simple dataset in Power BI desktop and published so we can share it in Workspace.

We created semantic model using OLEDB and data import. Once published we wanted to incremental refresh it once a month however the data source credential getting error.

Our DWH data source is in Azure Management Instance (Tenant A)

Our Power BI service comes with our Subscription of Office 365 (Tenant B)

The Power BI Service data source is not able to connect for both Basic and OAuth2 method. Would anyone be able to advise? Is there a Microsoft support we can contact to configure this?

Thank you.

N

[Nnnn0015 · Accepted solution]

Just to update on resolution.. after almost a month of working with MS Power BI support team

1. Whitelisting of *.powerbi.com urls - after group call, our system/network team proceeded with allow list - https://learn.microsoft.com/en-us/fabric/security/power-bi-allow-list-urls
2. Installing On-Prem Data Gateway - initially support tried to install on my computer but did not work due to permission / proxy setting / dns configuration. In the end, system team install it in 1 of our VM (used by DBA to run SSIS packages) - environment somewhat both have access to internet (public) and intranet (private) network. 
3. Configuring FQDN DNS - our connection to Azure MI is using with "privatelink" private endpoint. MS Azure MI support recommended the DNS config and our system team enable the connection to Azure MI FQDN without privatelink for Power BI Service.

[Anonymous]

Hi @Nnnn0015,

I am glad that you were able to solve your issue with the help of Microsoft Supprt Team. As you have already mentioned the workarounds, can you please mark it as solution so that other community members can find the solution easily.

Best Regards,

Hammad.

[Anonymous]

Hi @Nnnn0015,

Thanks for reaching out to the Microsoft fabric community forum.

It looks like you are facing issue with refreshing your semantic model in PowerBi Service. As @lbendlin already responded your query, please go through his response and check if it solves your issue.

Also if you are unable to solve the issue and wants to connect with Microsoft Support then you can reach out to Microsoft Support by raising a ticket with Microsoft Support.

Please refer below link on how to raise a contact support or support ticket.
How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

I would also take a moment to thank @lbendlin, for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.

If I misunderstand your needs or you still have problems on it, please feel free to let us know.  

Best Regards,
Hammad.
Community Support Team

If this post helps then please mark it as a solution, so that other members find it more quickly.

Thank you.

[Anonymous]

Hi @Nnnn0015,

As we haven’t heard back from you, so just following up to our previous message. I'd like to confirm if you've successfully resolved this issue or if you need further help.

If yes, you are welcome to share your workaround and mark it as a solution so that other users can benefit as well. If you find a reply particularly helpful to you, you can also mark it as a solution.

If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.
Thank you for your patience and look forward to hearing from you.

[Nnnn0015]

Hi @Anonymous ,
We have raised Microsoft support for this and still on progress from Network/Infra. The suggestion is to open firewall for *powerbi.com since both Power BI service and Azure MI are in cloud. 

Will update this thread again when it is resolved. Thank you

[lbendlin]

There's a lot going on here.  Check this out Introducing Cross-tenant Power BI Dataset Sharing | Microsoft Power BI Blog | Microsoft Power BI  and also make sure you have a gateway if required by your setup.

Incremental Refresh has its own very specific set of requirements, but you'll want to fix the connectivity first.

[Nnnn0015]

Thank you for your insight @lbendlin 

We can now narrow our issue;

1. Data source and Power BI Service needs to be in same tenant

- will check with Infra if they can do this.

2. To create Data gateway

- Which gateway should we go for? Is there difference between on-prem and vnet gateway?

[lbendlin]

Ideally you want to avoid a gateway (ie your data source is directly visible from Azure)

On-Prem:  requires you to set up multiple on-prem VMs that have direct line of sight to your data source

VNet:  managed by Azure, requires subscription.