Hi,
I started working with Office long time ago using Excel and Access (for bigger data) and my work changed so I lost a bit the development in terms of working in office with (big) data. Since some months I discovered Power Query in Excell which has some very good advantages to me:
Easy to do filters/queries
a lot faster like Access back in time
possibility to connect to folders (I have all my csv/xlsx Files in one folder so, it's very useful to me that data gets automatically published when adding a new file)
I see one big disadvantage which is perhaps no disadvantage because I do not know how to handle it. Power Query is sticked to my Excel File. So I find it a bit complicated to grab data when I want to have for example a report build from scratch with a new file using my Power Query data. What I really would aim for is to have a database in the Power Platform which I can easily access with every app (Excel, Power Bi, Power Point) which has quite the same funcionality like Power Query.
Any recommendations are very welcome.
Thanks.
Share
Report
All responses (
Answers (
1,990
