sio / LibPQ

Detach your M code from workbooks to reuse it! Import modules from local or web storage (unlimited number of sources)
Apache License 2.0
76 stars 21 forks source link

Feedback from users #12

Open sio opened 6 years ago

sio commented 6 years ago

Hello! If you are using LibPQ (or have used, or have tried to use it but something didn't work out for you) - please leave some feedback in comments below.

Any feedback beside the three points above is also greatly appreciated! Thank you!

spythan commented 5 years ago

Hello!

Thank you a lot for the work you've done, your project helps me in my Power BI workflow so much! It allowed version control, automation, and text editor selection already for me, and I'm about to use your Unit Testing framework!

I would like to ask if there is currently a way to use LibPQ on Power BI Service?

sio commented 5 years ago

Thank you for your feedback! I'm glad you find LibPQ useful :)

I have never tested LibPQ with PowerBI service, and I have no access to the service to do such tests. When I started writing this reply my initial idea was that LibPQ should work fine as long as you use only web sources in LibPQPath, but then I did some googling... It seems that the base URL for Web.Contents has to be static, which is not the case for LibPQ at the moment. I have some ideas on how to fix that, but I will need your help to test the changes in PowerBI service. Please join me here :+1:

B-D-T commented 4 years ago

LibPQ disabling Power Query intellisense?

I apologize if I'm missing something, but it appears that adding LibPQ breaks the Power Query intellisense. In Excel workbooks where I don't have LibPQ/LibPQPath, I get the intellisense function list, arguments, etc. But for those where I've integrated LibPQ, the intellisense only reads objects that were defined within the existing module.

Almost all my work is done directly in M in the Advanced Editor. Having intellisense makes that process easier, but now that I've discovered the wonderful LibPQ, I don't want to give that up either! Any suggestions?

sio commented 4 years ago

@B-D-T, thank you for reporting this! I've branched your question off to a separate issue #20. See my comment there.