Pulling SharePoint Online List with Managed Metadata into Power BI

-
Recently, I started to work with Power BI for one of my projects. I am impressed and presently supersized. Product is simple and powerful keeping up to its name.  But, its not free from bugs.

 Like Force.com I always wondered if SharePoint Online can be used as PaaS. One of the major backdrop for me was reporting until I explored Power BI. In this post I am going to cover a bug which will fail sync between  SharePoint Online List with Managed Metadata and Power BI. 

Error: 

Expression.Error: We cannot convert a value of type Record to type Table.Details:Value=Record Type=Type


You may encounter this issue in another form. If you try to expand taxonomy column, it will take forever. 


Work Around: 


In Power BI Desktop, instead of using "Sharepoint List" under "Get Data" use "OData" and supply REST API URL instead. 

https://tenantname.sharepoint.com/sites/SiteName/_api/Web/Lists(guid'xxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxx')/Items

Login with Organization Account. It should work seamlessly. 

At the time of writing this post Power BI is facing syncing issues. If you run into one of them.


After you publish the data source to PowerBI online and check the settings, you see the following error. 

"Your data source can't be refreshed because the credentials are invalid, Please update your
credentials and try' again."

The solution is simple. Edit credentials. Select OAuth2 and reenter credentials. 

Comments

  1. latesttechnologyblogsOctober 10, 2018 at 2:30 AM

    Thanks for sharing this Informative content. Well explained. Got to learn new things from your Blog onpower bi online course

    ReplyDelete
  2. James ZicrovAugust 10, 2019 at 6:16 AM

    Thank you so much for providing such a descriptive information on SQL and REST API.This post very clearly and cleverly throws light on some good aspects of REST API.

    Powerbi Read Rest


    ReplyDelete
  3. Veera BlogspotDecember 12, 2020 at 12:00 AM

    Hi.
    Grat article with excellent content.
    Thank you for sharing this awesome blog,keep updating...

    Power BI Online Training

    ReplyDelete

Post a Comment

Feedback - positive or negative is welcome.

Popular posts from this blog

COM Add-in Deployment Issues

-
Environment:  Visual Studio 2010, Office 2010, Excel 2010 Error: "Another version of this product is already installed"? Solution: 1.       Try uninstalling the application from "Add and remove programs" 2.       If the above step doesn't resolve the issue, run EXE from the command prompt with /x option 3.       Delete Application cache On Vista, it is located at C:\Users\ \AppData\Local\Apps\2.0 4.       As a last step take a backup of the registry. Search for "DSExcelAdd-in" and delete the corresponding entries. PLEASE TAKE THE BACKUP as needed. (esp. Keys under VSTA and VSTO (HKEY_USERS) Error: Name: From: file:///C:/publish/DSExcelAdd-in.vsto ************** Exception Text ************** System.ArgumentException: Value does not fall within the expected range. at Microsoft.VisualStudio.Tools.Applications.Deployment...
Read more

Sample code to upload a file to chatter feed using REST API

-
Image
Step 1: Download required files Download the following files from internet httpcomponents-client-4.2.3-bin.zip org.apache.commons.httpclient.jar From the files, I have added following JARS to my project in eclipse.    Screenshot from Ecclipse Step 2: Get Access Token Through Chrome Login to your Salesforce instance and navigate to Setup -> Create -> Apps.  Create a custom app and fill Client ID and CallBack URL (ex: http://www.google.com) in the following URL. Encode the CallBack URL before passing it as a parameter.  https:// <instance_name> .salesforce.com/services/oauth2/authorize?response_type=token&client_id= <Client_ID_Goes_Here> &redirect_uri= <CallBack_URL> Paste this URL in chrome In Developer Tool -> Network select "preserve log upon navigation" Load the page. We see below page. The page will take us to RemoteAccessAuthorizationPage.apexp which inturn will lea...
Read more

Salesforce.com migration tool - Deploying Weblink and migrating files with special characters

-
Image
Recently, I noticed the followed issues in SFDC Ant deployment. Issue 1: Typo in XML <name> metadata data for Web Link Just to reiterate, all the buttons and links created under "Buttons and Links" section of the Object are treated as Web Links . Screenshot from Force.com Migration Tool Guide It should be WebLink, not Weblink. Otherwise, the following error occurs while extracting the package :  package.xml - Entity type: 'Weblink' is unknown. Correct XML is:  <types> <members>Opportunity.Cancel_CheckOut</members> <members>Opportunity.Generate_Deal_Sheet</members> <name>WebLink</name> </types> Issue 2: Unable to deploy entities with special characters Example: <types> <members> User w/Export  </members> <name>Profile</name> </types> I tried to deploy Profile entities with special characters like '-' and '/...
Read more