Hi, I have an excel file which I want to do data transformation in M. How do I connect the excel file to my VStudio. Already installed SDk and PowerQuery M but it keep asking credentials are required..?
Many thanks, very useful as I wanted to start using visual studio for M language, as I'm fed up with the time it needs for my queries to refresh on the PQ editor. One question though: why not use Vs code to do that? The only difference I can see is that ok Vs code you can't sho the result, right? I just started today so...
This is the only meaning full video I have found on Power queri sdk. Thanks One question: how can I use this to create a custom connector with source as web API authentication: anonymous bearer token . And set auto refresh using personal gateway. Please check
wtf, i have like 20 excel worksheets that have a script in power query. I could make a project with the 20 of them , and just put them in a ETL or SQL job so users dont have to run them manually? that would be amazing! Edit: I've been testing this and its pretty good, except for one little detail. How do i export the results? I need to command to export directly to a file. Im not sure if you can run R commands in the same script? If you could, that would be insane for automation.
Not sure there is a way you can orchestrate and export it from Visual Studio. There is supposed to be a Power Query extension for SSIS and Power Query is also coming to Azure Data Factory. Another alternative is using Power BI Dataflows but bring your own datalake so you can access the file the dataflow produces.
Unfortunately not available for visual studio 2022 x64 yet
Love all the hand written M.
Bananas! Thank you Jhonny!
Btw is it able to connect to this sdk file directly from power bi?
Hi, I have an excel file which I want to do data transformation in M. How do I connect the excel file to my VStudio. Already installed SDk and PowerQuery M but it keep asking credentials are required..?
Many thanks, very useful as I wanted to start using visual studio for M language, as I'm fed up with the time it needs for my queries to refresh on the PQ editor. One question though: why not use Vs code to do that? The only difference I can see is that ok Vs code you can't sho the result, right? I just started today so...
Yeah, if your happy writing in VS Code without being able to check the output, you totally can. I prefer being able to see the result is all
This is the only meaning full video I have found on Power queri sdk. Thanks
One question: how can I use this to create a custom connector with source as web API authentication: anonymous bearer token . And set auto refresh using personal gateway. Please check
hello, thanks for your video, please I need to get Data source hosted on Dropbox to powerBI, do you know how?
Bootiful 🍻
wtf, i have like 20 excel worksheets that have a script in power query. I could make a project with the 20 of them , and just put them in a ETL or SQL job so users dont have to run them manually? that would be amazing!
Edit: I've been testing this and its pretty good, except for one little detail. How do i export the results?
I need to command to export directly to a file. Im not sure if you can run R commands in the same script? If you could, that would be insane for automation.
Not sure there is a way you can orchestrate and export it from Visual Studio. There is supposed to be a Power Query extension for SSIS and Power Query is also coming to Azure Data Factory. Another alternative is using Power BI Dataflows but bring your own datalake so you can access the file the dataflow produces.
@@GreyskullAnalytics it took my entire weekend but i managed to do it with active x + power query sdk.
Niiiiice! you should do a video/blog on it