Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

No session exists for database with ID

Submitted by Anonymous on ‎02-28-2020 12:33 AM

I have a issue with all my reports that are connected to power bi service datasets.
If I start from blank with PBI desktop everything is fine. BUT when I download existing pbix file from service which is connected to powerbi dataset and try to open it with PBI desktop I get he error message "No session exists for database with ID: xxxxxxx".

This error completely prevents the pbix file opening.

 

I'm using the latest powerbi desktop version installed from MS Store.

Status: New
See more ideas labeled with:
17 Comments (17 New)
Comments
Anonymous
Not applicable
‎03-03-2020 11:19 PM

Hi all,

 

It seems that the problem is with Version 2.78.5740.981 64-bit (Feb 2020) which is installed from MS Store. 
2.79.5768.421 64-bit (March 2020) version is not available for me in Store yet so I cannot test it.

In my other computer I have version December 2019 which is working fine as mentioned above.

 

The problem is that in my primary computer as well as many of our customers do not have admin rights to install programs to their coomputers and therefore MS Store version is the only possibility. It's also great that from Store the program is updating automatically in background.

 

It is good that we have a work arounds (different version or Solution founded by @twailly) for urgent needs.

 

Anyway hopefully the new version will be available in MS Store as soon as possible (if it fixes this)!!!

twailly
Frequent Visitor
‎03-03-2020 11:47 PM

@Anonymous, create a new file in powerbi desktop and get data from the dataset (the one used in the files that you cannot open).

1tcook
Frequent Visitor
‎03-16-2020 11:50 AM

@twailly, I tried that and it did not work. I used two differrent zip utilities to control for differnece in the compression process to no avail. 

I was able to create a copy of the file in the Service but it contains the entire model. If I could change that data source to point to the service that would be great. Can't do that though.

Anonymous
Not applicable
‎03-16-2020 11:16 PM

I got the latest version from MS Store yesterday (Version: 2.79.5768.721 64-bit (March 2020))... No changes to this issue 😞

Anonymous
Not applicable
‎03-16-2020 11:33 PM

@1tcook 

When you create a copy in Service open it in desktop

1. Go to query editor and remove all tables

2. If you have any additional tables added by DAX code in desktop, remove those as well. So you have a desktop file with visualizations but no data at all

3. When you have removed data tables you can connect to Power BI datasets again

 

1tcook
Frequent Visitor
‎03-17-2020 07:59 AM

*GROOOoooaaann". I knew that. I have done it before and totally forgot about it. 😖

Thanks.

 

 

artemmuntianu
Frequent Visitor
‎04-03-2020 02:02 AM

We faced same issue recently. There are two ways to fix it:

 

1) Update PBID to the latest version. Now it is 2.79.5768.1082 64-bit (March 2020)

 

2) Open your PBIX report in WinRar (or any other archiving app) and remove connection string from Connections file. It may look like {"Version":2,"Connections":[]} after that. Remove file SecurityBindings.

That's all, now you can open it in PBID and re-connect to any dataset you want.

Idea Statuses