Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Unable to delete Data Source in PowerBI Service using PowerBI API

Hi,   I have uploaded a pbix file that uses Mixed Storage Mode (Direct Query and Data Import) to the PowerBI Service. The file has only one Azure SQL data source, say Dev-DataSource.    After the...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Jayendran So, it looks like Update Parameters call created a new data source instead of replacing the existing one. I am using the "datasets/{datasetId}/Default.UpdateParameters" API call to update parameters.

 

Below is a screenshot of what I see in Dataset Settings:

 

 

Could it be because of the composite data model? Since both Direct Query and Data Import tables point to the same data source, one of them is updated while other is not?

Anonymous's avatar
Anonymous
Not applicable
6 years ago

I confirmed from the data in the report, that while all Data Import tables are pointing to "QA-DataSource", Direct Query tables in the model are still pointing to the "Dev-DataSource", and did not get updated by the UpdateParameters call. 


How can I update the data source for Direct Query tables in a composite data model? Is there another API call for this?

  • Jayendran's avatar
    Jayendran
    Solution Sage
    6 years ago

    Hi Anonymous ,

     

    From the screenshot it seems you are having 2 different data source credentials, in other words your both query like import and direct using 2 different data sources and credentials.

     

    I'd recommed to update/create both the queries (import mode and direct query mode ) to get the values from the parameters like database and server names 

     

    Ideally you should have a single parameter(s) (servername/database) for your both queries (import and direct query )

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi Jayendran ,

       

      As I mentioned in in my first message, the pbix file has only ONE data source "Dev-DataSource" for both direct query and import queries. It is using parameters to populate the connection string for this data source. I am trying to update the data source in PowerBI Service using REST APIs after the pbix has been uploaded. 

       

      The screenshot above is after I ran the following APIs to update parameters and credentials for "QA-DataSource":

      • datasets/{datasetId}/Default.UpdateParameters POST
      • gateways/{gatewayId}/datasources/{dataSourceId} PATCH

      Running above APIs creates a second data source (credentials) in the service. So, now I see both QA-DataSource and Dev-DataSource both.

      By running the report I found out that the Data Import queries were updated to point to QA-DataSource, but the ones using Direct Query still point to Dev-Datasource. 

       

      Is this scenario not supported?