Posted by10 months ago
Archived
Hello Guys,
I'm new in this sub and i would like to ask something regarding PowerBi and PowerQuery. In my job, we have an old VBA macro that do a bunch of stuff, sorting, calculating between 4-5 tables. People are complaining because this is quite slow to execute.
I'm learning a bit PBi and PowerQuery but i dont know where will be the limitation of them ? Am i able to do the same stuff than VBA with PBi and PowerQuery ? Is that worth to learn VBA now ? Or directly PBi and PQuery ?
Thanks :)
8 comments
Hi I saw this power shell script which can connect to power bi and export more data than the normal limit that is allowed from power bi.
This script works and exports to a csv file from power bi, any ideas if this can be acheived through VBA or any other suggestion of a way to connect to power bi desktop (pbix file) using VBA in order to extract data. Or can VBA call power shell?
The reason i'm asking is to export from power bi. You can export data from power bi desktop but there is a limit. One way around this.is this power shell script .but can it be done from VBA. I'm more familiar with vba and power shell may require system privileges. There is also a way using language 'r' but im asking if you can do it in VBA R way to export fyi.
ozmike
ozmikeozmike1,92211 gold badge2222 silver badges2727 bronze badges
Is this question similar to what you get asked at work? Learn more about asking and sharing private information with your coworkers using Stack Overflow for Teams.
Browse other questions tagged vbapowerbiadomdanalysisservices or ask your own question.
Download call of duty 2 for android. I am not sure why you ask the question because you are not comparing apple to apple. The 2 tools are designed for different purposes:
- VBA is a programming language. It is the programming language designed for Excel users. It is designed as the way you think in Excel, you can easily automate your task by recording it in Record Macro tool and modify the code as you wish. Macro recording is very powerful and provide a low level entry for Excel user who has little coding training and experience to automate task without even understanding the code! With that said, VBA can make you feel very powerful at first but you should consider it as an entry programming language. It’s good for quick automation, but will not work in the long run. However, due to the ease of development and very little learning effort compared to other languages, many serious applications that suit business needs have been developed in VBA by people without technical background.
- Tableau/PowerBI are visualization tools. Basically they provide more powerful chart drawing and updating capability than Excel. It because they recognize data structure and you will be able to draw chart by selecting column headers rather than selecting the cell ranges like in Excel. They also provide more types of charts with the most relevant visual design for each chart, so you don’t have to adjust chart design to make it look suitable for reporting.
If you ask which one should you learn first, or focus your limited time on learning, I’d say learn Tableau/PowerBI. You need those skills right away as a data analyst.
Forward looking, you might never need to use VBA, because it has become (almost) standard that a data analyst should be able to use Python (well at least in technology company). You could avoid it (not everyone loves coding) and that’s totally fine as long as you find a relevant company and position. But if you need to learn a programming language, choose Python.
I have a big Automation process project using Vba and Power BI.
Power Bi Or Vba File
My question:
Is it possible to refresh your Power BI File using a macro?
7thGen7thGen
closed as unclear what you're asking by RADO, Storax, greg-449, Rakesh, NeekuApr 22 at 10:40
Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
1 Answer
In theory - yes, in practice - no (at least it isn't recommended).
You can refresh a dataset in Power BI Service using Refres Dataset and Refresh Dataset In Group REST API calls. In general it is possible to make web service calls in VBA and should be possible to authenticate and acquire access token (required to use Power BI REST API), it looks much more manageable and easy to implement if you write this code in a .NET asspebly and call it from your VBA code, or to call a PowerShell script, than writing and dedubing VBA. You wont find any working samples, because nobody does it this way. I also think that from security perspective it is very bad idea.
You should reconsider redesigning your automation process.
Andrey NikolovAndrey Nikolov
Power Bi Vba Macros
5,00833 gold badges99 silver badges2222 bronze badges
Got a question that you can’t ask on public Stack Overflow? Learn more about sharing private information with Stack Overflow for Teams.