Power BI
Last Published Date
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.
myBMT.DataView Usage Analysis
DataView Exec get.myView analytics for Prod DataMartsDataView Usage Analysis
My first Power BI
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
Wireframe
https://www.figma.com/file/kletVWU6qcByYaT8nQgNjA/Pinstone-Designs?node-id=28%3A2&t=w4RvyzKMdtaWXCGf-1
Create SQL table from parquet files
https://stackoverflow.com/questions/62935557/create-sql-table-from-parquet-files
Paged API List
Table: Runn_people Function: fRunn_api