The underlying connection was closed: The connection was closed unexpectedly

[debiagui]

Hi in last weeks I'm using Analysis Service to connect to a dataset with:

= AnalysisServices.Database("powerbi://api.powerbi.com/nnn/org/workspace", "Dataset", [TypedMeasureColumns=true, Implementation="2.0"])

The connection now is falling with this error.

Can someone help me?

[lbendlin]

What is your reasoning for not connecting via the Power BI Datasets connector?

[debiagui]

Hi Ibendlin, really I'm using Excel Power Query to connect to a dataset an deliver an specific report to a team without require to use Internet, they are in a zone with a poor internet quality.

[v-shex-msft]

HI @debiagui,

As lbendlin said, I don't think you can directly use AS connector with power bi service URL. You need to use power bi service connector with published datasets. 

In addition, if you are work with the poor quality network, maybe you can try to export the data to local DB or file(use import mode instead of the 'data link' to external data sources) then you can use power bi to get data from them.  
Regards,

Xiaoxin Sheng

[debiagui]

Hi @v-shex-msft, maybe I explain in a wrong way. I'm following this kind of connection:

https://docs.microsoft.com/en-us/power-bi/admin/service-premium-connect-tools

I've created the full logic of my report inside of power bi, if I'll use a local db I need to re-create it.

I use power query in excel and connect to powerbi://api.powerbi.com/v1.0/[tenant name]/[workspace name]

Also I've tried to export the dataset to a local db using DAX studio, but it fails with one of my tables.

I've found that solution, and for the last week I could share the "offline" report, but last couple of days I got this error

[debiagui · Accepted solution]

After some days, the connection was working again