This post helps you solve the below issue in Power BI.
Scenario: There will be an error when we connect with 32-bit Access Database from Power BI 64-bit desktop.
Error: “Microsoft Access: The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine”.
To solve the above issue, follow the below steps.
Once completed the above steps, try to connect access DB from Power BI desktop. This time you will be able to connect without an issue.
Post your comments if you get any more issues in this scenario.
In my previous post, I have explained the possibility of using SSRS shared dataset as a source for Power BI report. Refer my previous post here.
In this post, I am giving you the detailed step by step procedure to work with the shared dataset in Power BI.
Follow the below steps,
Step 1: Open Power BI Report Server portal URL. For example, the URL is like below.
Step 2: Add the following extension with the above URL. /api/v2.0/datasets. It will list out all the datasets with ID as like below.
Step 3: Filter the dataset with ID. Here I used the second dataset id.
Step 4: Open Power BI Desktop and choose OData feed data connector
Step 5: Pass the above URL as like below.
Step 6: Choose advance and select “Include open type columns” checkbox to get all the columns of the dataset.
Step 7: Click Ok and select Edit Option on next screen.
Step 8: Select the icon near the “More Columns” as like below. It will list out all the columns.
Step 9: Uncheck the “Use original column name as a prefix” and click ok. Finally click “Close & Apply”.
Step 10: Choose the fields and create a report.
Thanks. Let me know if you face any issues.
Following Satya’s quote “Empowering Every Person in the Planet”, in 2016 Microsoft Inspire conference, have certainly left my mind with unstoppable beats. I certainly understood what Satya meant, but I still thought about doing something like this, with my own upgraded version of Data Awareness Programme (which I started in 2014). But at that time, all I had was Power View, Power Map, Power Pivot as Excel add-ons and tried my best, to do the awareness programmes in remote villages, by mingling with the villagers and collecting their own data and showing some visuals back to them. I did this to improve their life style, find more time for personal and have better earnings. Though the main target was students, I hoped this message would spread to their friends, family and others in the remote places.
Following the release of full version of Power BI, I now have a fully working site, with living “Awareness Enabled Reports”, from sleeping open data sources (taken from various Gov/Non-Gov sites).
I managed to get this far, with a simple equation of A + B + C + D = E (EmpoweringEveryPerson.com (EEP)). Let me explain this in detail.
With our all time favourite reporting tool, “Microsoft Power BI“, published some “Awareness Enabled Reports” to www.EmpoweringEveryPerson.com site and categorized them with regional, national and global challenges, for easy manoeuvring within the EEP site.
This EEP site currently has 3 simple goals.
Below screenshot shows categorization of reports by UK.
PROMOTE & PARTICIPATE
As per above equation, ‘D’ is the support that we need from you, to promote in any of the following ways.
2. COMMUNITY LEADERS
A request to all Community group leaders, to spend at least a minute by starting or ending your user / local / online group sessions by introducing / re-introducing, this website and showcasing the opportunity to all attendees, to build and submit their own data story with “Awareness Enabled Reports“.
3. END USERS / VOLUNTEERS
Every time you see a new “Awareness Enabled Report“, do tweet / share / post in social media and support to spread the awareness.
Thanks in advance for your support and thanks for your time reading through this far, to create awareness with “Awareness Enabled Reports“.
Creating a Power BI report is very easy, and it supports loads of data connectors. When we start creating a report against any relational database, we must choose any of the below query modes,
2. Direct Query or Connect Live
For example, when you try to create a report against SQL Server database, then you need to choose any of the above methods based on the requirement.
If you take SSRS report server, we have below elements available
1. Paginated Reports
2. Mobile Reports
4. Data Sources
If you are SSRS administrator, then you can easily manage all these stuff in a centralized place.
Is it possible to use the SSRS dataset to create a Power BI Report?
Yes, it is possible. You must have the latest version of Power BI Report Server.
We have REST APIs and is supported in Power BI Report Server, which is an extended version of SSRS 2017. Check REST API on SSRS 2017.
We need to use the OData Feed data connector to connect with SSRS datasets.
Below is the information required to create a report.
1. REST API Url
2. REST API Url with specific dataset id
The base URL of the REST API will be like below,