1. Create a blank query in Power Query Editor like so: 2. Keep “Include in report refresh” unselected. 3. Create a Card visual to show “LastPublishedDate”. 4. Before publishing the report, you need to refresh the data of the “LastPublishedDate” table, not refresh the report.
DataView Exec get.myView analytics for Prod DataMartsDataView Usage Analysis
Create Parameters Create two parameters… Use a Token on myBMT The token allows the Datawarehouse to identify with the source of the report, as PowerBI cannot send environment details. (answers on a postcard please, if you know how) So the token is used to give the report a unique identifier myBMT | Token (bmt-dwh-uks-app-my.azurewebsites.net) Navigate … Read more
https://www.figma.com/file/kletVWU6qcByYaT8nQgNjA/Pinstone-Designs?node-id=28%3A2&t=w4RvyzKMdtaWXCGf-1
https://stackoverflow.com/questions/62935557/create-sql-table-from-parquet-files
Table: Runn_people Function: fRunn_api