granite-cs / PowerBiVisibility

A script for researching PowerBI pbix files, useful for versioning and tracing DAX dependencies.
GNU General Public License v3.0
24 stars 8 forks source link

Update bash script from today #2

Open johnfelipe opened 6 months ago

johnfelipe commented 6 months ago

Can u update script for run into 2023 windows version....

https://github.com/granite-cs/PowerBiVisibility/assets/428820/6062d438-47fc-40ea-8779-9b7eee59824d

Use 'Powershell ISE' instead of the command line.
(because the ordinary powershell command line does not preserve tab characters)
Enter 'c' to cancel (for any choice)
Enter 'p' for a file picker
Paste the full path to the PowerBI file: C:\folder\example.pbix: p
Do you want:     SQL Insert script (s)   <-- blank choice uses this
            Tabbed Delimited Table (t)
                 JSON of PBIX file (j)
               Measure Expressions (m)
                     Detailed Logs (l)
                       combination (stjml)
.................Enter Your Choice:
Copying from d:\Users\GAMEMAX\Desktop\SimuladorV2.pbix
Copying to   D:\Users\GAMEMAX\Desktop\PowerBiVisibility-master\Temp_File_Delete_Me.zip
Copied
Unzipped
JSON read ...transforming
Temporary Files Removed
Evaluating the PBIX file
    (some JSON data is ignored)
Evaluating the Data Sources of open PBIX files
Get-Process : No se encuentra ningún proceso con el nombre "PBIDesktop". Compruebe el nombre del proceso y ejecute de
nuevo el cmdlet.
En D:\Users\GAMEMAX\Desktop\PowerBiVisibility-master\PowerBI Visibility.ps1: 641 Carácter: 1
+ Get-Process PBIDesktop | foreach-object{
+ ~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : ObjectNotFound: (PBIDesktop:String) [Get-Process], ProcessCommandException
    + FullyQualifiedErrorId : NoProcessFoundForGivenName,Microsoft.PowerShell.Commands.GetProcessCommand

Finding dependencies
done

The SQL script will now be copied to your clipboard and also displayed.
press Enter to continue.:
johnfelipe commented 6 months ago

https://github.com/granite-cs/PowerBiVisibility/assets/428820/63515c99-77cd-4641-abda-63995461f9f5

this is using t option