Month: June 2024

Task list automation with Power Query

I like when tasks are actionable. Saying “Fix the overview-page” as a task isn’t very useful to anyone! How do you know what to do and when you’re done? What if the task was instead “Decide on a name for the overview page”, “write a description for the overview...

Alternative to USERELATIONSHIP

From time to time you want to add RLS to your Power BI model. If you do, then the filtering option USERELATIONSHIP isn’t supported. Another scenario is that you filter on a date and you want to show things that has anything to do with that date, not just...

Listing all tables from Business Central

If you’ve ever worked with Business Central as your data source, you’ll know that you have 3 different endpoints to connect to. Within each, you’ll find tables of data. Sometimes, the table you’re looking for will be found in V2.0, other times in Odata (Webservices) etc. When you connect...