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.