Data Recovery Archive

How to Navigate and Search Content with Power BI

Posted April 21, 2019 By AuthorVS1

In this article, we look at using Power BI to Navigate content. We also provide tips for using the tool for searching and even sorting content in workspaces.

Organizations often have to deal with a lot of trouble managing tons of data, which is flooding their systems with thousands of files folders and documents. Accessing required data in the mess of these databases can sound like a nightmare. But thankfully there are features like Power BI with which users can actually access their data without getting entrapped in the database jungle.

Navigate and Search Content with Power BI

Power BI is used for content organization. It is responsible for categorizing and separating user’s content into reports, datasets, workbooks, and dashboards. It also helps in classifying different types of content making it easier for the user to locate it.

Content created by the user for his personal space is stored in My Workspace, while the content which is shared by the user is stored in App Workspace. Content which is used frequently or demands quick access is stored in Favorites. Content which has been shared with the user is saved in Shared with me and last-viewed content can be access through Recent. If all of these Power BI’s are used properly then the user will be able to keep his/her system organized at all times.

Note: One additional and very effective way of organizing your content is by picking up the dashboard that you are likely to use frequently and setting it up as your own featured dashboard. Each time the user will open Power BI service, this dashboard will automatically display first on his/her screen.

Favorite Dashboards and Apps

Users can mark as many as files as their favorite as they like, this helps in ensuring that they have a quick access to their documents. It can also be beneficial for other users who operate through the user system to allocate these files. 

Users often are unable to keep a track of all the files that they access or visit while working on a project. Well, by setting these files as their favorite, user will be able to access them whenever they want. The best part about these features that users can undo these setting and un-favorite these files when they are no longer required on a daily basis.

Tips for Searching and Sorting Content in Workspaces

A workspace consists of four Content Tabs: Dashboard, Workbooks, Reports, and Datasets. And they all comprise of a sort button and a search field. When a user starts off using Power BI service, he/she might not find it beneficial as it will comprise of two or three items in each tab. However, with time users will create a long list of folders with their content, which will make it essential for you to use the sorting and searching tools effectively.  

In order to find a file or folder, from your database, the user just needs to write the name of the file in the search bar given in the dashboard. In order to sort their search results, the user can use the content sorting feature ‘SORT By’ available on the current page. The options will be sorted based on the name of the file or according to the recently used files.  

Irrespective of the version of SQL Server you are running your office; it makes great sense to invest in a SQL Server recovery tool.

Author Introduction:

Victor Simon is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including access recovery and sql recovery software products. For more information visit www.datanumen.com

Be the first to comment

In this article, we explain solutions to the SQL Server error for ‘Event ID not found’.

Apart from all its features and functions, SQL Server can also be a storehouse of confusion if you are not very familiar with all that it provides and what all it can be used for. For all the events and operations that we perform in SQL Server, we can refer to the event log for details. But keeping in mind the high-end features and some complexities of the application, there might also be times when you are completely unable to find a given Event ID from the SQL Server source.

Solve “Event ID not found” Error in SQL Server

Error

Your SQL Server application’s event log might be troubling you with an error that fails to give you the details of an Event ID from SQL Server Source. You can try searching the error log, but it might prompt you with an error message that says that password you entered was not correct, and did not match. This appearing error message might just be showing you placeholders for all you know. One of the main reasons why this happens is because a file is missing and the event viewer has been enabled for decoding the message to show just place holders.

You might get more information on the occurring error by checking the sys.messages. The correct message can still be found in event log.

Solution

Since the error message we are viewing is showing only placeholders, we know that encoding is enabled and we are seeing a decoded version of the same, but not the complete text. This decoding takes place mainly because of a file that has been stored in a registry key.

Depending on what kind of instance you are making use of, you will be able to find a path to the same. For a default instance, the path will be found in ‘EventMessageFile’. Once you are able to find the path of the instance, you will also know its location. One of the main reasons why you were not able to find it in the event log can be because the version was incorrect.  You can try copying it from any other machine and then reopen it in event viewer.

Once you perform this action, you would be able to get the complete information for the Event ID.

Important Points

As and when we start working on SQL Server there are a lot of features and functions that we are not aware of, with the time we not only begin understanding them but also learn how to make the best of them. However, as a user of the application, it is important for you to know that even the most experienced of DBAs can often come across unforeseen errors when making use of the application. By attempting to figure out solutions you would never get stuck at any of the errors you experience in the application. As at the end of the day you can always take help of a repair SQL Server tool in case you experience a more severe problem.

Author Introduction:

Victor Simon is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including access recovery and sql recovery software products. For more information visit www.datanumen.com

In this article, we look at roles being used to grant permissions on the report server. We also look at who sets these permissions how these permissions are stored.

Reporting Services in SQL Server use a role-based authorization and authentication subsystem in order to determine the users who can perform an operation or access items on a report server. Role-based system is used for categorizing authorization of different roles and action which can be performed by a user or a group. This authentication is based on custom authentication module or built-in Windows Authentication that is provided to the users. Users can custom or predefine roles using either of these authentication types.

How Permissions can be Granted in Report Service

Using Role to Grant Permissions on the Report Server

All users interact or access a report server based on the role that is defined to a specific level for a specific person or a group. Reporting Services include predefined roles which can be assigned to users or groups in order to provide them with immediate access to interact with a report server. Content Manager, Browser, and Publisher are some common examples of these predefined roles. Each of these roles, define a collection of different related tasks. For instance, a Publisher has the permission of adding reports and creating folders for storing these reports.

Role assignments are inherited from the parent node, but users can break this permission of inheritance by simply creating a new role of assignment for each particular item. Note that a user can be a member of Content Manager Role in one report and might also be a member of another report for of Browser role.

Guidelines for granting access to different report server operations and items

1.    Review all predefined roles and determine whether they can be used as it is. If the user needs to adjust any tasks or define any additional roles, he/she should do it before assigning users to specific roles.

2.    Identify users or groups that require access to that particular report server, and on what levels. Most users are assigned to Browser role or Report Builder role. And only selective users need to be assigned for Publisher role. And Content Manager Role should only be assigned to the trusted officials.

3.    Use Report Manager for assigning roles in the Home folder for each group or user who requires access.

4.    Then go to Report Manager’s Site Settings page and create an assignment for system-level roles for each group or user, using predefined roles System Administrator and System User.

5.    Create additional assignments for assigning access to specific folders, reports, and other items. Avoid creating too many role assignments.

Who Sets These Permissions?

Initially, Report server can be accessed by the local administrator’s group or its members. Reporting Services are installed with only two default roles assignments which are used for system-level and granting item-level access to local administrators group and its member. These groups and members are responsible for assigning permission to other users.

How Are These Permissions Stored?

Report Server stores its role definitions and assignments in its database. If a user uses multiple programmatic interfaces or client tools, the access is subjected to the permissions which are defined as a whole for the report server. Role assignment is stored with all the items that they secure, that allow the user to move a database to a different report server without losing the defined permissions.

While MS SQL Server is a highly advanced platform, it still ends up getting plagued by data errors. Always keep a powerful SQL Server repair tool around to deal with unexpected data errors.

Author Introduction:

Victor Simon is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including access recovery and sql recovery software products. For more information visit www.datanumen.com