search

didierterrien / Power-BI-Sidetools

Power BI Sidetools is a free Power BI external tool intended to increase productivity during reports development in Power BI desktop.
69 stars 7 forks source link

No connection through External Tools button #26

Closed hlynurarni closed 1 year ago

hlynurarni commented 3 years ago

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: no_connection

When I launch the app through search run_search

Then I get the connection like this succ_connection

didierterrien commented 3 years ago

At the moment, Sidetools doesn't work with live connected pbix. I agree the behaviour you describe looks strange. Can you share a report so I can try to reproduce the different behaviours ?

didierterrien commented 3 years ago

And can you send to me the log file please ?

hlynurarni commented 3 years ago

I will have to figure out a way to strip the report so I can send it. But yes it is connect directly to Power Bi service.

We create a separate .pbix datafile and make a live connection as you mention to Power Bi service. The .pbix datafile gets the Sidetools connection established correctly but the report doesn't, if that wasn't clear.

Power BI Sidetools log.txt

didierterrien commented 3 years ago

Thank you. When you launch the external tool, the log must show the command line like this : [07-19-2021 17:39:20] Command line : "localhost:59746" "688f66d7-adc0-4234-9a4d-8296b6379e82" Did you remove these lines ?

hlynurarni commented 3 years ago

I have not edited the log file

EDIT: This is an old log file I have from V1.2.4.0 so this has nothing to do with my version of Sidetools at least.

Power BI Sidetools log.txt

didierterrien commented 3 years ago

It's my mistake, the next version will show the command line.

didierterrien commented 2 years ago

There is a test version available for 1.2.5. Can you install it and reproduce the error then send to me the log file ?

hlynurarni commented 2 years ago

Running on test version 1.2.5

I get this when I use the external tools button in Power BI

image

But I get this when I use the search option to launch the tool

image

It is constantly updating with some xmla update. I then close the tool resulting in the "End" close in log file. Hope this helps.

Log file is here: Power BI Sidetools log.txt

didierterrien commented 2 years ago

I published V1.2.6 test version. Can you try it ?

Test version 1.2.6 is meant to

DAX generator provides 2 files repositories containing DAX formulas. One contains your own DAX templates (user templates) and the second one contains DAX templates written by experts (featured templates). Those templates contain a DAX formula and several instructions for the DAX generator. Instructions declare parameters so the user can change the measure name, tables name, columns names, values in few clicks. Then the user generates the DAX formula which can be pasted in Power BI desktop, Tabular Editor, DAX Studio, ... DAX generator provides the possibility to create or update measures with one click in the desktop. An other click allows to debug DAX formulas in DAX debugger.

hlynurarni commented 2 years ago

This is the message I get when I launch sidetools:

image

I do not have the ability to run SideTools from my search bar anymore...

The update feature looks nice but after I hit process I get download packages and another message that goes too quickly away (installation something)

I get both this:

image

And this:

image

image

When I try to install the test version again I sett a update message if I want to remove or repair my program (have not noticed that before)

image

I will later evaluate the DAX additions, but I can see it is there.

image

image

didierterrien commented 2 years ago

Thank you very much for your tests !

  1. 'Power BI Sidetools warning' window is normal as there is no model available in the Pbix even if you create measures in the thin report. Daniel Otykier mentionned it might change.

  2. I added back the shortcut so I suppose you can launch Sidetools from the search bar now

  3. The 'Update control' small window was not supposed to appear. I removed it. The bigger one is correct. If you click on 'Process', you revert to version 1.2.5. You need to install again V1.2.6 if you want to test it more

  4. The messages you got in the 'Power BI Sidetools update' are normal

  5. You chosed correctly 'Repair' in the install window. This dialog will disapear in the production release.

  6. The Zip file you saw will be uncompressed and deleted when you will launch DAX generator for the first time. It contains featured templates (templates created by experts). At the moment, there are only 2 templates for the demo.

didierterrien commented 2 years ago

I published a new V1.2.6 version with these corrections

hlynurarni commented 2 years ago

I am NOT able to use the update to new version feature that you introduced in the test version v1.2.6. Hitting the process does not work, there comes an error that goes really quickly but I managed to capture it:

image

The layout folder I am missing in live reports (Discussion). I cant reproduce it with the test version since I get the same "live reports..." message even though I launch it from the search menu.

Now I try to install v1.2.5 again and get no warnings about another sidetools program being installed that results in this:

image

Look closely, the size of the v.1.2.5 install is only 10.5 MB.. and even if after uninstalling the v1.2.6 I still get the live report connection prompt like I am running v1.2.6 (it is uninstalled...)

Now I uninstall both of them and install v1.2.5 without having any prior Sidetools version installed and I see this:

image

Now we are back, to what I assume is normal, 12.1 MB install, strange behavior that I don't understand.

Hope my explanations made sense :)

Is it possible to have the same workaround in test version 1.2.6 where I can still make the connection (through search launch) and get the layout files out (this is crucial for us to be able to run this in production)?

didierterrien commented 2 years ago

Thank you for your investigations ! I corrected some issues with thin reports. With version 1.2.7, you are supposed to be able to run PBI to files on a thin report whenever you run Sidetools from 'External tools' tab or from the search bar :

But you get at least the layout files

The installation error is traced in the log file. Please send it to me if auto update still doesn't work You will need to uninstall V1.2.5 manually at the end of your tests

didierterrien commented 1 year ago

Thin reports are better supported with latest versions. They are still not fully supported. I close the issue. Feel free to reopen it with explanations.