search

metamoof / lapsang

A framework for establishing and auditing Active Directory with Power BI
2 stars 0 forks source link

Power BI: set up a publish to onedrive option as a way of testing the file online #15

Open metamoof opened 6 years ago

metamoof commented 6 years ago

This could be a useful way to publish the file to PowerBI for automated testing.

According to the docs saving a Power BI file to onedrive or sharepoint allows updates to that file to be sideloaded automatically to the Power BI service.

It might even be possible to use the Power BI API to upload the report, and/or update and link to the dataset

metamoof commented 6 years ago

@metamoof Or here is how to read the power BI desktop OLAP cube: https://community.powerbi.com/t5/Desktop/Storing-and-using-information-from-a-dynamic-data-source-using/td-p/207293/page/2

metamoof commented 6 years ago

@metamoof See also https://github.com/DevScope/powerbi-powershell-modules/tree/master/Modules/PowerBIPS.Tools which appears to do a lot of stuff we need to do

metamoof commented 6 years ago

Having Tested with PowerBIPS.Tools, it has a perfectly adequate Export-PBIDesktopToCSV command that we can use to read the powerquery output against a known CSV file

metamoof commented 6 years ago

@metamoof This method does not actually test the powerquery; it tests the resulting table after applying DAX to the powerquery data

metamoof commented 6 years ago

@metamoof I wonder if I can use the EVALUATE command in the MSSAS backend to run unit tests in M