Forum Discussion
Impactful Individualdns or ssas error on desktop even when dowloading pbix with data
Hi this is a bit puzzling. A peer of mine got this error on a sql engine based pbi report after downloading the pbix to his desktop. He tried with data. He tried with connections. Same error both ways. I know semantic models use the veripac engine but this is a head scratcher. i dont know if this is a region thing, he is clear across the country from us on the west coast whereas we are basically in the mid west. We havent seen this error before.
AI was way off on this one.
WOW! i just learned today that this was a problem with our internet service provider in what i think is a new company location. Not only did this problem go away, but another pbi issue related to spreadsheet data sources went away too. My apologies to the community.
7 Replies
- rajendraongole1
Super User
Hi db042190 - If you can share what the “Data source settings” show in their PBIX (just the connection string text), I can tell you exactly whether it’s tied to SQL or the Power BI Service model.
can you test the connectivity:
nslookup pbidedicated.windows.net and also check for the ports are open or not. eg. 443
learning doc: fyr:
Connect to Analysis Services data in Power BI Desktop - Power BI | Microsoft Learn
Hope this helps.
db042190thx rajendraongole1,
in power query...= Sql.Database("server", "db name", [Query="SELECT...
in the cloud, semantic model shows ...sql server and then contained between braces 2 pairs, one with "server" as label and server name and one with "database" as label and db name
in datasource settings in transform i see servername;databasename
semantic model in cloud shows it was refreshed this morning at 7:42 am
we'll try the other 2 items you asked for here shortly.
- db042190
the dns wouldnt resolve. so i think we want to resolve that first. and then issue this command , maybe from powershell?
Test-NetConnection pbdedicated.windows.net -Port 443 -InformationLevel Detailedwe'll post results back here.
v-echaithraCommunity Support
Hi db042190 ,
We’d like to follow up regarding the recent concern. Kindly confirm whether the issue has been resolved, or if further assistance is still required. We are available to support you and are committed to helping you reach a resolution.
Best Regards,
Chaithra E.- v-echaithra
Hi db042190 ,
May I ask if you have resolved this issue? Please let us know if you have any further issues, we are happy to help.
Thank you.
