Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi
I am trying to get something simple to happen. In SSRS I could populate a datasource that I choosed to populate real time into SSRS.
I am now trying to do something similar with JsonResult from MVC and Power BI. The c# code does all the manipulation and I just need to display it in Power BI purely as an interface of LIVE data.
I have added two parameter ReportRegion and Report. This was added in "parameters" using "Manage Parameters" and the paramaters are set to Text.
I am using a iframe as such:
<iframe width="800" height="600" src='http://XXXX/Reports/powerbi/FirstTryB?rs:embed=true&report=@Model.Search.Report&reportRegion=@Model.Search.ReportRegion' frameborder="0" allowFullScreen="true"></iframe>
XXX is the localhost Power Bi report server. The report loads fine, but the parameters and live data is ignored. The exact opposite of what is required.
These parameters should populate the source:
Json.Document(Web.Contents("http://localhost:51930/Report/StandardData?report=" & Report & "&reportRegion=" & ReportRegion))
I cannot get these two parameters to work at all. They must chage every time the iframe is loaded. The iframe keeps hitting the cached version and never requests live data and completely ignores the paramaters passed in. This cannot be a scheduled refresh.. it must be LIVE data.
Is there any way to parse the parameters from iFrame all the way to Web.Contents? Report Server must be local and not a external cloud server so using the cloud is not an option
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
6 | |
4 | |
3 | |
3 |
User | Count |
---|---|
15 | |
9 | |
6 | |
3 | |
3 |