Skip to main content
To homepage To homepage
Solved

Creating Sematic models PBI

T
Starter

Hello,

I am trying to setup an endpoint to PowerBI Premium in version 20 (20.10.58)  The connection is setup as below, and it tests OK (See pic).

When I Deploy I get the error:

Failed to save modifications to the server. Error returned: 'Either the database with the ID of 'TXFinance1' does not exist in the server with the ID of 'host002_datasets-231', or the user does not have permissions to access the object.

The Semantic model is created fine in PowerBI, but nothing inside of it.

Is there a setting I am missing? The stange thing is that it appears to work for a colleague in the same workspace using the same app credentials, but not on my machine 

 

Many thanks,

Tim

Best answer by rory.smith

Hi,

I assume your app registration is admin on the relvant workspace? Have you taken over the dataset and edited the data source settings? You will likely also need specific versions of the client libraries (x64_15.0.2000.443 for ADOMD, AMO, OLEDB).

View original
Did this topic help you find an answer to your question?

7 replies

G
Community Manager
Forum|alt.badge.img
  • Greg Lennox
  • Community Manager
  • 27 replies
  • April 28, 2025

​@Tim Turner If you go to your Power BI Workspace and check the Manage Access, do you have the same level as your colleagues for which this is working?

There are some settings regarding the Power BI Premium Per User settings that are described in the article below, in case this is useful.

 

 

Christian Hauggaard
Community Manager
Forum|alt.badge.img+5

​@hugo.winkelhorst I believe you are using this workaround at a client, deploying to PBI xmla from 20.10. Do you have some ideas?

​@Tim Turner please note that deploying to PBI in 20.10 is not officially supported, and we recommend migrating to TimeXtender Data Integration to deploy semantic models directly to PBI

rory.smith
TimeXtender Xpert
Forum|alt.badge.img+7
  • rory.smith
  • TimeXtender Xpert
  • 689 replies
  • Answer
  • April 29, 2025

Hi,

I assume your app registration is admin on the relvant workspace? Have you taken over the dataset and edited the data source settings? You will likely also need specific versions of the client libraries (x64_15.0.2000.443 for ADOMD, AMO, OLEDB).

Christian Hauggaard
1 person likes this
  • Christian Hauggaard
    Christian Hauggaard
Christian Hauggaard
Community Manager
Forum|alt.badge.img+5

Hi ​@Tim Turner do you have an update on the above?

T
Starter
  • Tim Turner
  • Author
  • Starter
  • 2 replies
  • May 5, 2025

Hello Christian,

thanks for your support and your suggestions ​@rory.smith 

I think the issue is the Versions of the client libraries.. I am struggling to find where I can download them.. Can anyone point me to where I light find them?

thanks

Tim

 

Thomas Lind
Community Manager
Forum|alt.badge.img+5
  • Thomas Lind
  • Community Manager
  • 1071 replies
  • May 5, 2025

Hi ​@Tim Turner 

https://docs.microsoft.com/en-us/azure/analysis-services/analysis-services-data-providers

From this guide in the old support system.

https://legacysupport.timextender.com/hc/en-us/articles/210437663-Error-Could-not-load-file-or-assembly

T
Starter
  • Tim Turner
  • Author
  • Starter
  • 2 replies
  • May 7, 2025

Great thanks I managed to download the providers version below and they worked.😀

 

rory.smith
1 person likes this
  • rory.smith
    rory.smith

Reply


Most helpful members this week

Terms and ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings