Forum Discussion

AntonioCasado's avatar
AntonioCasado
Frequent Visitor
6 years ago
Solved

Parameters aren't published to PowerBI Service

Hi all,

Probably I am missing something with the changes included in the last Power BI Desktop Update (because I have some old datasets with parameters working correctly).

The thing is that Power BI Service shows me the message "Parameters haven't been defined for this dataset yet. If you want to set parameters, use the Query Editor" even when I created parameters in the dataset via Power Query Editor.

Here you have the steps I did:

1. Create two parameters: DBServerName and DBName

2. Create a new source with both parameters in the "connection string":

let
Source = Sql.Database(DBServerName, DBName),
TEST_DIM = Source{[Schema="TEST",Item="TEST_VIEW"]}[Data]
in
TEST_DIM
3. Enter the credentials, and the data were loaded successfully.

4. Close and Apply chages

5. Create the test report.

6. Check that both parameters exist going to "Transform data" -> "Edit Parameters"

7. Save the report.

8. Publish to Power BI Service.

9. Sign in Power BI Service.

10. Go to the correct Workspace.

11. Go to datasets tab

12. Click on settings in the published dataset

13. When you try to change the parameters on the settings page the message "Parameters haven't been defined for this dataset yet. If you want to set parameters, use the Query Editor".


Any help, please?

 

Thanks in advance.

  • Hi, AntonioCasado 

     

    Based on my research, the paramterized datasource can be published to Power BI Service. However, you can't modify the value in Power BI Service. As is said in the official document ,you can review and edit some parameter settings in the Power BI service -- not parameters that restrict the available data, but parameters that define and describe acceptable values. I'd like to suggest you use Power BI restful api to achieve you requirement.

     

    For further information, you may refer Datasets - Update Datasources In Group and use new data source to replace the old one.

     

    Best Regards

    Allan

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

5 Replies

  • v-alq-msft's avatar
    v-alq-msft
    Icon for Community Support rankCommunity Support

    Hi, AntonioCasado 

     

    Based on my research, the paramterized datasource can be published to Power BI Service. However, you can't modify the value in Power BI Service. As is said in the official document ,you can review and edit some parameter settings in the Power BI service -- not parameters that restrict the available data, but parameters that define and describe acceptable values. I'd like to suggest you use Power BI restful api to achieve you requirement.

     

    For further information, you may refer Datasets - Update Datasources In Group and use new data source to replace the old one.

     

    Best Regards

    Allan

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • AntonioCasado's avatar
      AntonioCasado
      Frequent Visitor

      Hi v-alq-msft ,

       

      First of all, thank you for you reply.

       

      Sorry, that is exactly what I am trying to implement. I am involved in a Continuous Integration process that publish the new reports automatically making use of the Power BI Rest API via PowerShell scripts. So I need to change the server name and database name dynamically (as Guy in a Cube shows in https://youtu.be/MJVSu47iMmo?t=131)

       

      The thing is that I did some demos a couple of weeks ago, and it worked! but, recently, something has changed and parameters are gone.

       

      Here you have a demo I did:

      1. This is the PowerQuery setup. As you can see, I defined two parameters.

       

      2. I published the dataset into PowerBI Service. As you can see there it was published on 03/12/2020.

       

      3. And as you can see here, I can edit the parameters. So everything was working as expected until a few days ago.

       

       

       

       

      I have also tried the symulator in the Update Parameters in group documentation, but it seems that the parameters hasn't been published:

       

      Thanks.

       

      • AntonioCasado's avatar
        AntonioCasado
        Frequent Visitor

        Hi v-alq-msft ,

         

        I have redone my script to use Update Dasource in Group, instead of update parameters. And it seems to be working.

         

        Thank you very much.

         

        Regards.