Forum Discussion
Helper IDynamic subscriptions for paginated report - Parameters greyed out
I am setting up a dynamic subscription for a paginated report following the steps outlined in Dynamic subscriptions for paginated reports (Preview) | Microsoft Power BI Blog | Microsoft Power BI.
I am able to set Recipients, Email subject, and report format. However, when I get to the Parameters page in the set up, I cannot select "Get from data". It is greyed out. How do I enable the parameter to get data from the table?
I figured out the issue. The parameter must be TEXT data type in the Power BI Report Builder. It was a INTEGER since the FacilityID was a number. Once I changed it to TEXT, the Get from data option was enabled. Hopefully in the future, it will allow data types other than TEXT.
1 Reply
wjbreitenbachI figured out the issue. The parameter must be TEXT data type in the Power BI Report Builder. It was a INTEGER since the FacilityID was a number. Once I changed it to TEXT, the Get from data option was enabled. Hopefully in the future, it will allow data types other than TEXT.