Business Intelligence

Introduction How do I use Row Level Security in Power BI?  Is it true that I need to use Roles to manage security?  Where are the permissions granted?  Can you walk through an example demonstrating how to setup Power BI Row Level Security? To answer all this questions and to help business to avoid it, on bConcepts we have consultants that has security services on the mind...

Read More

Dynamic Data Driven Subscription in SSRS Business Problem: In one of our report requirement, we need to feed the data files to robot for every one hour. For that, we have created an hourly subscription for that report. As a result, we were sending many empty files to robot, which makes the system resource degradation. To overcome this issue we have to create a subscription to send the...

Read More

Overview: The Power BI dataset must be refreshed according to the schedules defined so that the reports will have latest data. We must manually configure the refresh intervals in Power BI scheduler. Once data is populated in Structured Zone from landing Zone in Azure environment, Power BI refresh must be scheduled. Thus, always manual intervention is required if they have different schedules and in case of long...

Read More

Power BI is a collection of software services, apps, and connectors that work together to turn unrelated sources of data into coherent, visually immersive, and interactive insights. Your data may be an Excel spreadsheet, or a collection of cloud-based and on-premises hybrid data warehouses.With Power BI, one can retrieve data from hundreds of data sources, shape the data to fit your specific requirements, perform ad...

Read More