Forum Discussion

FireFighter1017's avatar
FireFighter1017
Icon for Advocate III rankAdvocate III
1 year ago

Dataflow query in desktop do not obey parameters set values

I got a dataflow that we have published in a workspace that is part of a deployment pipeline (DEV-QA-PROD). I have defined parameters to allow changing the workspace Id and dataflow Id in Power BI S...
Need Help
FireFighter1017's avatar
FireFighter1017
Icon for Advocate III rankAdvocate III
1 year ago

Hi Anonymous ,

 

So here are my test results (so far):

1. Clear Data Source Settings in Desktop:

  • Go to File > Options and Settings > Data Source Settings.
    • Didn't do anything.  Still reads from last working location
  • Clear permissions for Power Platform and remove cached connections.
    • Permissions was cleared in previous step (I think?). 
    • Removing cached connections, I don't know how to do that

2. Inspect PBIP Files in Git:

  • Check parameters.json – confirm the right values are set.
    • We're using PBIP/TMDL without PBIR.  I could not find that file.
  • Check connections.json – this may have hardcoded workspace/dataflow IDs that override parameters.
    • We're using PBIP/TMDL without PBIR.  I could not find that file.