Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

Tom dataset refresh programatically

When I try to connect to Power BI workspace using XMLA endpoint to refresh datset am getting "Invalid connection string format"

public static void ConnectToPowerBIAsUser()
{
string workspaceConnection = "powerbi://api.powerbi.com/v1.0/myorg/Superstoresales";
string userId = "test@nousinfo.com";
string password = "********";
string connectStringUser = $"DataSource={workspaceConnection};User ID={userId};Password={password};";
server.Connect(connectStringUser);
}

 

sowmyas_0-1637824151433.png

 

Can we refresh TOM dataset using Premium Per User Power BI License or Do we require Premium per capacity license.

1 ACCEPTED SOLUTION
V-lianl-msft
Community Support
Community Support

We can refresh TOM dataset using PPU.This may be a credential problem. Please see the limitations here and choose the correct access method:

Single-user application - The application uses a single user account or app identity to access a Power BI dataset through the XMLA endpoint. Typical examples are developer tools, admin scripts, and automated processes to perform data modelling and administrative tasks, such as altering the metadata of a dataset, performing a backup or restore operation, or triggering a data refresh. The user account or app identity that the client application uses to access a dataset must have a valid Premium Per User (PPU) license unless the dataset resides on a Premium capacity.

Multi-user application - The application provides multiple users with access to a Power BI dataset. For example, a middle-tier application integrating a dataset into a business solution and accessing the dataset on behalf of its business users.

  • For Premium Per User (PPU) workspaces, the application must require each user to sign in to Power BI. The application uses each user’s access token to access the datasets. The application is not permitted to use a service account or other app identity to perform tasks on behalf of its users. Each user must use their own Power BI account for opening reports, accessing datasets, and executing queries.
  • For Premium workspaces, the application may use a service account or app identity on behalf of the end users without requiring each user to sign in to Power BI.

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

View solution in original post

1 REPLY 1
V-lianl-msft
Community Support
Community Support

We can refresh TOM dataset using PPU.This may be a credential problem. Please see the limitations here and choose the correct access method:

Single-user application - The application uses a single user account or app identity to access a Power BI dataset through the XMLA endpoint. Typical examples are developer tools, admin scripts, and automated processes to perform data modelling and administrative tasks, such as altering the metadata of a dataset, performing a backup or restore operation, or triggering a data refresh. The user account or app identity that the client application uses to access a dataset must have a valid Premium Per User (PPU) license unless the dataset resides on a Premium capacity.

Multi-user application - The application provides multiple users with access to a Power BI dataset. For example, a middle-tier application integrating a dataset into a business solution and accessing the dataset on behalf of its business users.

  • For Premium Per User (PPU) workspaces, the application must require each user to sign in to Power BI. The application uses each user’s access token to access the datasets. The application is not permitted to use a service account or other app identity to perform tasks on behalf of its users. Each user must use their own Power BI account for opening reports, accessing datasets, and executing queries.
  • For Premium workspaces, the application may use a service account or app identity on behalf of the end users without requiring each user to sign in to Power BI.

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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.