Azure access for PowerBI online

[ADijkstra]

Hi all, 

What I'm struggling with at the moment:

• We have an Azure tenant with 1 SQL server and 3 databases running
• I have created several PowerBI reports in the desktop version, everything works well
• When publishing the reports, I get an error for most of the visuals, but not all: 
  • Error fetching data for this visual, A connection could not be made to the data source with the Name of '{"protocol":"tds","address":{"server":"tcp:db-.......windows.net","database":"sql-........database"},"authentication":null,"query":null}'.
    
    

I have tried using workspaces, app registration in Entra ID, etc. Firewall is set to allow access, roles and groups as well.

The only thing I can think of is a gateway, but seems to me we should be able to manage access without if some of the visuals return with data. 

What am I missing?? Thanks for your help!

[v-agajavelly]

Hi @ADijkstra ,

Great to hear you got everything up and running. If the SCCs plus the encryption setting adjustments were the fix, which solution works for you mark it as accept the solution so others hitting the same issue can benefit from it too.

Regards,
Akhil.

[ADijkstra]

Hi all, 

Yes thank you for your help again. The SCCs worked in the end, I needed to also adjust a few settings in encryption. 

All up and running now!

[v-agajavelly]

Hi @ADijkstra ,

I hope the response was helpful in resolving your issue. If you have any further questions, please don’t hesitate to let us know we’ll be happy to assist.

Thanks,
Akhil.

[v-agajavelly]

Hi @ADijkstra ,

Just following up were you able to configure the SCCs and adjust the semantic model settings? Happy if that cleared up the visual loading issues in the Service, or if you’re still seeing the same behavior.

Regards,
Akhil.

[v-agajavelly]

Hi @ADijkstra ,

Just checking in to see if you had a chance to configure the SCCs and update the semantic model settings as suggested by super user. Did that help resolve the visual loading issues on the Power BI Service? Let us know if it's all working smoothly now or if you're still running into any hiccups, happy to assist further if needed.

Regards,
Akhil.

[v-agajavelly · Accepted solution]

Hi @ADijkstra ,

Thanks for sharing the detailed context. Also, big thanks to @tharunkumarRTK  for the spot-on solution.
The suggestion around setting up SCC and properly mapping them in the semantic model settings under Gateway and cloud connections is correct and aligned with Microsoft’s official documentation.

@ADijkstra  Follow the steps provided by Super user. Once you configure the SCCs for all databases referenced in your model and map them correctly, this should resolve the visual loading errors in Power BI Service.

Let us know how it goes.

Regards,
Akhil.

[tharunkumarRTK]

@ADijkstra 

Since you have mentioned that you have enabled the network rules. I would suggest you to configure the SCC, i.e sharable cloud connection. You can follow these instructions:

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

depending on number of databases that you refereed in your power bi seamantic model, you need to use those many connections in your model. (If there is any error while creating those connections then you need to fix it)

After creating all the required connections, open your semantic model settings and expand "Gateway and Cloud connections" section and map the connections properly. 

If everything goes well then you will be able to see the data in your report page. While creating the connections if you get Network reated errors then you need either open the firewalls or install the gateway 

Connect on LinkedIn

Did I answer your question? Mark my post as a solution!
If I helped you, click on the Thumbs Up to give Kudos. Proud to be a Super User!

[ADijkstra]

Thank you for your help! 

So I followed the steps and now the report shows the error for all visuals, not just most.. So even the ones that were previously working.

Any further ideas? 

Appreciate the help!