Forum Discussion
Cannot add dynamic values into text box
Hi all,
I have now solved and hope this can help others. The problem is related to my report that had both dataset and visuals in the same PBIX file. Originally t was split in two separate PBIX (Dataset and report) that I later merged into a single PBIX. In this way the textbox visual couldn't see the columns and the measures of my model even if they were in the same file. Now that I have separated semantic model and report (as best practice is teaching) everything works correctly. In essence your report has to be "connected live" to you data model in order dynamic values can be retrieved:
Hope this helps.
Regards,
C.
** FIGURED IT OUT **
Was having the same problem.
Long story short, broke my Report into Semantic & Report View - then later tried to re-merge these reports. The result was that the Q&A & Dynamic Text only worked in the original semantic report, but no longer worked in the merged report.
Initially, I thought this was because of the PowerBI versions - but after experimenting I learned that this issue wasn't due to the version.
HOW I SOLVED:
1. I learned from a different thread that if you try to EXPORT the Linguistic Schema - it will either succeed - or Fail (and give you an error message). Upon exporting, the error message gave me a specific error message that pointed me to a specific query in my dataset.
2. I went to the Query and DISABLED IT (uncheck "enable load")
3. SAVE AND UPDATE
4. The Error went away and the Q&A worked alongside dynamic text values
5. I went BACK to the query in query editor and RE-ENABLED it
6. SAVE AND UPDATE
7. Boom, Issue now resolved.
This issue cost me 3 days of productivity. If it helps you, thumbs up - and SPREAD THE WORD.
Thank you, you solve the problem!
It would be great to declare this answer as the accepted solution instead.
I don't know how to do it...
