dns or ssas error on desktop even when dowloading pbix with data

[db042190]

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.

[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.

[v-echaithra]

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.

[rajendraongole1]

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.

[db042190]

thx 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]

hi rajendraongole1 and community support.   First of all this issue isnt resolved yet.   I'm going to share where we are in language i speak but i am not a network guy so bear with me.   

out network guys used utilities available to them to not only try resolving that dns from the location where my peer got the error on the west coast, but also to simulate the same from different geo locations in our network.

the way it was explained to me , that dns simply doesnt exist ANYWHERE, internally or externally.   i saw the results of their tests.    so that dns is xxxxxxxxx-northcentralus.pbidedicated.windows.net.   I have to find out if the part i've obfuscated with x's in any way violates our rule of not sharing secure info.

so in my limited capacity i am already wondering why him opening a pbix on the desktop would try to reach something very external looking in the first place.   so what i think i am going to do is have one of our network guys "spy" on what servers me opening a pbix , in my part of the country, on the desktop (i've never gotten such an error) try to reach and perhaps draw some conclusions.   I do notice that part of that name looks like an ms regional data center but who knows.   also, the fact that semantic models use the vertipaq engine makes me wonder if the analysis services part of that error is something we shouldnt be ignoring.    so far we've been focused on the dns part.  the person getting this error may not understand when i ask him if he downloaded the pbix with data.   we're trying to get him started.

[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 Detailed

we'll post results back here. 

[db042190 · Accepted solution]

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.