didierterrien / power-bi-sidetools Goto Github PK

Hi Didier
What a wonderfull tool you have made :-)
Is it correct, that it does not work in a PBIX connected live to SSAS?
Regards, Henrik

I'm getting the following error in excel when trying to export from the pbix file:

"Sorry, we couldn't find Export to Excel.odc. Is it possible it was moved, renamed or deleted?"

Thanks Didier, regards

Pablo

Hello,

After installing and trying to open the external tool from Power BI Desktop, I got this error. Would a portable version fix?

Thanks

"A pbix file couldn't be found. May be you didn't save your report. Power BI Sidetools will run with limited features. If you want full features, just close Sidetools, save your report and run it again."

Log:
[12-16-2022 09:34:44] Command line : "localhost:62588" "4e7f9148-f63b-4c5e-bcec-faaa0e6e47ea"
[12-16-2022 09:34:48] Power BI selected instance identified
[12-16-2022 09:34:49] Folders initialised
[12-16-2022 09:34:49] Power BI file name identified
[12-16-2022 09:34:49] Connected
[12-16-2022 09:34:49] File system watcher error : The path is not of a legal form.
[12-16-2022 09:34:49] Initialisation completed
[12-16-2022 09:34:49] Updates checked
[12-16-2022 09:34:57] Create Custom analyser directory
[12-16-2022 09:34:58] After create Custom analyser directory
[12-16-2022 09:34:58] File exists
[12-16-2022 09:34:58] Before unzip Custom analyser
[12-16-2022 09:34:58] After unzip Custom analyser
[12-16-2022 09:35:11] Create PBI Tools directory
[12-16-2022 09:35:12] After create PBI Tools directory
[12-16-2022 09:35:12] File exists
[12-16-2022 09:35:12] Before unzip PBI Tools
[12-16-2022 09:35:12] After unzip PBI Tools
[12-16-2022 09:35:24] B Process Click error : The path is not of a legal form.

I'm one of the rare users that uses my Win taskbar at the top instead of the bottom. Since the External tools manager loads at the Y:0 coordinate I assume it the taskbar is overlapping the top of the External tools window. The only way to move it is by right clicking the icon and selecting move from the taskbar which can be confusing to some. If possible is there a way you can have it detect the location of the taskbar and prevent it from loading behind it.

I have an error in the path when exporting my DAX measures.
M code is exporting fine.

Thank you for your help,

Hello,

I tried to change the default saved folder and restarted everything but it did not work.
I would like to point it to my Git repository that looks like this:
Git \ Reports \ Report A \ M & DAX Files
Git \ Reports \ Report B \ M & DAX Files

Add the Git\Reports path to PowerBI SideTools that would then create the Report A/Report B folders for each report with the M & DAX files within.

I can't figure out why this happens but sometimes when you launch SideTools there is an extension (GUID I assume) added to the folders name. After that you can't execute an action like "pbi to files". I highlight the middle out since I don't know if there is any information in it.

HI!

Just found a quick bug.

We have created a dummy calculated table and stored our measures under this table. When exporting measures and calculated tables to files, the calculated table shows with CT but the measures saved under this calculated table don't get exported.

Cheers,
Benoit.

Hi!

When trying to export my (big = 700MB) model to files, only 2 root folders get created, the M and the DAX ones, and then only 1 subfolder is created under M, QG_ Diagnostics. And none of those folders contains any file.

Would there be a way to know why it is failing?

Here is the log:

=== V1.2.1.0 ======================
[05-10-2021 18:10:24]  Folders initialised
[05-10-2021 18:10:25]  Power BI file name identified
[05-10-2021 18:10:26]  Connected
[05-10-2021 18:10:26]  Initialisation completed
[05-10-2021 18:10:26]  Updates checked

It would be nice if the entries we have to make for the measure name that shall be debugged and the table name for the evaluation context would be case insensitive.

Hi,

Thank you for producing a wonderful tool.

Unfortunately I am unable to get the DAX debugger working, am I missing something?

Kind Regards
David

Every time I try to use the PowerBI Cleaner it results in an error. Below is the log file:

[10-29-2023 12:27:51] Command line : "localhost:49675" "8e43a252-0670-4f0d-b436-8a6748867634" "pbi_cleaner"
[10-29-2023 12:27:51] Power BI selected instance identified
[10-29-2023 12:27:52] Folders initialised
[10-29-2023 12:27:52] Power BI file name identified
[10-29-2023 12:27:52] Connected
[10-29-2023 12:27:52] Initialisation completed
[10-29-2023 12:27:52] Updates checked
[10-29-2023 12:27:52] Create Power BI cleaner directory
[10-29-2023 12:27:53] After create Power BI cleaner directory
[10-29-2023 12:27:53] File exists
[10-29-2023 12:27:53] Before unzip Power BI cleaner
[10-29-2023 12:27:53] After unzip Power BI cleaner
[10-29-2023 12:27:57] Create PBI Tools directory
[10-29-2023 12:27:58] After create PBI Tools directory
[10-29-2023 12:27:58] File exists
[10-29-2023 12:27:58] Before unzip PBI Tools
[10-29-2023 12:27:58] After unzip PBI Tools
[10-29-2023 12:28:01] Create info file error : Unexpected character encountered while parsing value: F. Path '', line 0, position 0.
[10-29-2023 12:28:01] B Process Click error : PBI Tools form raised an error : Unexpected character encountered while parsing value: F. Path '', line 0, position 0.
[10-29-2023 12:29:17] End
[10-29-2023 12:30:46] Temporary folder : C:\Temp\Power BI Sidetools

By default, the projects folder is in C:\Users\user\Documents\Power BI Sidetools. However, my Documents folder is not at this location, but is in my OneDrvie instead (C:\Users\user\OneDrive - organization name\Documents). When I change the project folder to be within this folder, Sidetools no longer works - at all. The directory name is only 82 characters long, so that does not seem to be the issue and I was able to use a project folder in another location with a space in the name, so that does not seem to be the issue either. I will use it in the default folder for now, but would much rather have it in my OneDrive folder.

After running 'PBI to files' none of the files were populated and the log reported this error:

=== V1.2.0.0 ======================
[04-26-2021 14:11:20] Folders initialised
[04-26-2021 14:11:21] Power BI file name identified
[04-26-2021 14:11:21] Check updated version error : Index was outside the bounds of the array.
[04-26-2021 14:11:22] Connected
[04-26-2021 14:11:22] Initialisation completed
[04-26-2021 14:15:17] Connected
[04-26-2021 14:18:02] Connected
[04-26-2021 14:19:47] End
=== V1.2.0.0 ======================
[04-26-2021 14:21:45] Folders initialised
[04-26-2021 14:21:46] Power BI file name identified
[04-26-2021 14:21:46] Check updated version error : Index was outside the bounds of the array.
[04-26-2021 14:21:46] Connected
[04-26-2021 14:21:46] Initialisation completed
[04-26-2021 14:21:49] Connected
[04-26-2021 14:34:34] End

The folder was located in my Documents folder, unconnected to OneDrive. Will try and look into further if I get the time.

Hello,

Thank you for your app, it will be very useful to export the M/DAX code to VSCode and Git.
I changed the default installation path (_C:\Program Files (x86)\The BI Power\Power BI Sidetools_) but then PowerBI Sidetools is not working in PowerBI - see picture.
I made it work after reinstalling with the default path.

With some reports I can't establish a connection by using the external tool button. Those reports do not include M or DAX code if that matters. I can establish a connection with other reports open beside it at the same time.

I have used the workaround of typing into search "sidetools" and run the app from there, that has worked for me.

Below are screenshots of how I experience the problem:

When I use the External Tools button:

When I launch the app through search

Then I get the connection like this

I tried out the latest test version 1.2.7 on 21. September

I got a none responding when I launched it ( I had another PBI desktop instance running that I didn't notice, before I installed the new version). After giving not responding some time I tried to exit the Power Bi desktop and when the application finally shut down --> all my apps and local files had vanished...

Really strange behaviour and I can't 100% confirm that it was Sidetools fault, but it looks like it. I don't have running computer at the moment because of this and just wanted to give you an update and maybe get your thoughts on why this could happen ?

When I specify //VAR DBG_ROWS_LIMIT = 20, I still get 30 rows in the debugger. I am using version 1.2.2 with the May 2021 (version 2.93.981.0 64-bit) version of Power BI Desktop.

I think the evolution of Power BI Desktop is causing some troubles in the ability to take back the dax and M code.

When the option "PBI to files when PBI is saved" is used it constantly executes and creates the files again. I have the folder structure open and I see the files disappear and show again in intervals of few seconds without me doing any action.

Only thing I have changed is the path to where I save the files, seems to me that this triggers this constant refresh. I have the folder with a dummy name on the same level as the .pbix.

After installing version 1.2.6 and launching it from the External Tools menu, it pops up a dialog box telling me the installed version is out of date, and asks if I want to update. It seems to be identifying itself as version 1.2.0 rather than 1.2.6. I double-checked the version number in the About tab, and it is indeed 1.2.6, though there is an extra ".0" on the end, so maybe that has something to do with it.

Where or how do I have to install VS Code to be detected?

Files -> Open VS Code ->
or
Folders -> Open projects folder in VS Code ->

Error opening process: "The system could not find the requested file" (translated)

would be great if the information that can be found on the blog would also be moved to the README.ME of this repo
https://thebipower.fr/index.php/power-bi-sidetools/

would also be nice to link the VSCode extensions directly:
https://marketplace.visualstudio.com/items?itemName=jianfajun.dax-language
https://marketplace.visualstudio.com/items?itemName=PowerQuery.vscode-powerquery

Hello

I believe there is an issue with ability to locate the executable file if the root is different from C:\

External Tools - Power BI Sidetools unable to locate the executable file if not in C:\

So, if I launch manually the executable, it works fine, but, the link from ribbon is not able to launch the executable (to locate it)

Regards

Amaury

I have just upgraded to portable version.
Excel files created using Export to Excel now save to a different sub-folder.
Is it possible for PowerBI Sidetools to retrieve Excel files created in previous version of Sidetools (those saved to C:\Users\your username\Documents\ ...) and so update their contents, or do I need to re-create from first principles?
Thanks
Bob

When using relative path, SideTools keep saving files into the default sidetools folder.

C:\Users<username>\Documents\Power BI Sidetools

Here is the log file:

Power BI Sidetools log.txt

Settings: