cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

The underlying connection was closed: The connection was closed unexpectedly

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Frequent Visitor

Re: The underlying connection was closed: The connection was closed unexpectedly

After some days, the connection was working again

View solution in original post

5 REPLIES 5
Highlighted
Super User V
Super User V

Re: The underlying connection was closed: The connection was closed unexpectedly

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

Highlighted
Frequent Visitor

Re: The underlying connection was closed: The connection was closed unexpectedly

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.

Highlighted
Community Support
Community Support

Re: The underlying connection was closed: The connection was closed unexpectedly

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
Highlighted
Frequent Visitor

Re: The underlying connection was closed: The connection was closed unexpectedly

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

Highlighted
Frequent Visitor

Re: The underlying connection was closed: The connection was closed unexpectedly

After some days, the connection was working again

View solution in original post

Helpful resources

Announcements
Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

August Community Highlights

Check out a full recap of the month!

Upcoming Events

Community Summit North America – Join Online!

Join this community-driven Power Platform digital event for unbiased support and problem-solving.

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Top Kudoed Authors