Business Intelligence projects are rarely linear. – Prof. Dr. Rowland Dax In general, BI projects consist of multiple components that need to be designed, created, and delivered simultaneously: data extraction, data modeling, DAX calculations, report design, data validation, and user testing, etc. Each of these streams depends on the other, and the process is mostly
Everything had been running fine while you were working locally to debug your newly written (or written a long time ago, doesn’t matter) Azure Function and got interrupted by a stupid error message one like following: Port 7071 is unavailable. Close the process using that port, or specify another port using –port [-p]. No worries,
If you are lazy like me to read the documentation in detail you would probably not know how to add application settings (local settings) to Azure function App. And you’ll probably realize that once you deployed 🙂 Azure Functions are interesting when it comes to saving and consuming settings. Current suggested method may seem like
You’ve always been a good developer and you do things according to the book. Therefore you used Azure Key Vault for keeping sensitive information such as connection strings. You’ve finished developing everything and published your Azure Functions App and wanted to check the Configuration and the Application Settings of your App. However, suddenly an Error
Technologies/Tools Used .NET Core 3.1 as Framework Swagger as API Frontend RepoDB as ORM Tool MS SQL Server 2017 as Database Visual Studio 2019 as Development Interface Create Solution and the Web Project Create an empty .NET Core API Project: Setup Swagger as an API Interface: Right click the project and hit “Manage Nuget Packages”
I am not a big fan of EF/Entity Framework. To be honest, mostly I hate EF. I have many valid reasons to hate it however I really don’t want this post to be the show of hatred against EF. Until today I was using my own Data Access Framework. It was not the best of
There are probably no one who uses Excel as a Datasource and hadn’t been haunted by that famous error: The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine. or better to say: this, when you try to install that provider: You cannnot install the 32-bit version of Microsoft Access Database Engine 2016 because you
Absolutely stupid tip but it is real. With the increase of high-resolution graphic cards (and the age of course) everything is getting smaller and sometimes it is more healthier and better for our old eyes to read results in bigger fonts. On the other hand it is especially required when you are doing a presentation
When there are multiple files to import there is an easy way to import these files at once to Power BI Desktop Application. You should utilize the Folder import method of Get Data functionality. To do this just follow “File > Get Data > More” and select Folder on right side or just write Folder
Power BI Online is not capable of importing Microsoft Access Database file (both mdb and accdb). To use MS Access DB as a datasource to conduct analysis, we should have to use Power BI Desktop first. You should open Power BI Desktop application and follow “Get Data > More > Database > Access Database” menu
