Skip to content
This repository has been archived by the owner on Nov 16, 2023. It is now read-only.

Not able to delete or update connection string of dataset using Azure analysis services server as data source #49

Closed
bhavinrathod opened this issue Jan 24, 2017 · 3 comments

Comments

@bhavinrathod
Copy link

I have issue in deleting dataset with live connection to data source. Is there any work around to solve this issue?

@Michal7
Copy link

Michal7 commented Jan 30, 2017

If you do not have any other datasets within workspace?

@bhavinrathod
Copy link
Author

bhavinrathod commented Jan 30, 2017

i have other datasets in workspace and i am using azure analysis services server as data source..if anybodt can help with connection string using azure analysis services server as data source

Even not able to update the dataset getting bad request error message.

@bhavinrathod bhavinrathod changed the title Not able to delete dataset with direct query Not able to delete or update connection string of dataset using Azure analysis services server as data source Jan 30, 2017
@Michal7
Copy link

Michal7 commented Jan 30, 2017

  • Power BI Embedded is not yet supported in preview, so make sure that you are using GA version.

Regarding the origin issue you mentioned I have had the same issue.
I solved it by this workaround.

  1. Create a new workspace collection
  2. Create a new workspace and upload pbix file with Direct query( so I have one dataset within workspace)
  3. Use ProvisionSample tool (remove first all configuration for app config) to update the connection string.
    3.1 Enter user name
    3.2 Enter user password
    3.3 Enter connection string in the format : Data Source=xxxx.database.windows.net;Initial Catalog=dbName;User ID=xxx;Password=xxx

Let me know if it work on your side.

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants