Forum Discussion

Korlay37's avatar
Korlay37
Frequent Visitor
1 year ago

PBI parametrized datasource report Upload with REST API and modify datasource through API Bad Req

Hello,  I have an application and I am implementing a report upload with the PBI REST API functionality which is working but I notice that once I import the pbix report with parametrized server and ...
Need Help
muhssamy's avatar
muhssamy
Resolver I
1 year ago

I can see you defined the data source as a table not a parameter this is the reason

you should create parameter in power query for the source and use it in the connection

Korlay37's avatar
Korlay37
Frequent Visitor
1 year ago

muhssamy How so?

I created the parameters when defining the  origin of my data, there they show as parameters and they are selectable when I select parameters as my connection information:

If I go to Transform Data -> Edit parameters they show there: 

 

If I open the transform data I see them there as parameters, I do not see any indication of them being tables:

 

  • Korlay37's avatar
    Korlay37
    Frequent Visitor
    1 year ago

    muhssamy After some testing it seems it is because I am publishing/importing it using the REST API instead of using publish from the desktop app... If I try and publish using the desktop app the parameters show up. So I am trying to understand why they do not show up when I use the REST API

  • muhssamy's avatar
    muhssamy
    Resolver I
    1 year ago

    i am using it like this could you please test it 

    after creating paramters i am using it in the connections

     

    NOTE:- this is a dummy example the server connection may need the port as you typed before

     

    • Korlay37's avatar
      Korlay37
      Frequent Visitor
      1 year ago

      I did what you did but I tried 2 scenarios with exactly the same report:
      * Publishing the report from the desktop application, it works and I can see the parameters there.

      * Publishing the report using my app and the Power Bi REST API, I cannot see the parameters.

       

      Unfortunately my flow needs to be through the REST API so I am trying to find out why the same report does not show parameters if I use the Post Import in Group. If you know the answer or if you have any suggestions please let me know!