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
Jayendran's avatar
Jayendran
Solution Sage
6 years ago

Hi Anonymous ,

 

The update data source/parameters itself meaning it will repalce the old data souces. so your old DEV will be replaced by QA. So why you are trying to delete the dev source , which already got replaced with QA.

  • 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 )