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.

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

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.