Forum Discussion

Nick's avatar
Nick
Frequent Visitor
10 years ago

Getting SharePoint List items with full history version?

Hi,   We do have a SharePoint list to manage Fleet inventory of asset: mainly their attribution (who own it) and their status (active, lost, broken, etc.). We did activated the SharePoint Version ...
Need Help
mzzwtr's avatar
mzzwtr
Regular Visitor
3 years ago

Hi harsh_bi_dev ,

 

could you show me how you connected the SharePoint Online List data source to your Power BI dashboard?

 

I followed this guide:

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-sharepoint-online-list 

 

Another question, could you show me what steps you took to publish your Power BI dashboard into your Power BI Service workspace?

 

I followed this guide:

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-upload-desktop-files


Hope this may help you.

 

Bye!

harsh_bi_dev's avatar
harsh_bi_dev
Frequent Visitor
3 years ago

Hello mzzwtr,

 

I'm getting the SharePoint List Item version history using the method mentioned in your initial reply as below:

It is creating another datasource as Web and when I'm trying to connect to it, it is showing me invalid credentials in Power BI Service. 

 

Please know that I'm adding new column by invoking custom function as below:

And if I go to datasource settings it will show me 3 datasources as below:

Please know that I'm using Gateway to connect to these datasources and it is showing the error of invalid credentials in Power BI Service but working fine in Power BI Desktop.

Hope this information will help you in understanding the issue I'm facing.

 

Let me know if you need anything else as well.

 

Thank you for the quick turn around.

  • mzzwtr's avatar
    mzzwtr
    Regular Visitor
    3 years ago

    Hi harsh_bi_dev ,

     

    I think the problem is related to the fact that you used a Gateway to connect your data source; since the data is in the Cloud, a Gateway is not required, as reported in the Microsoft documentation:

    https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem 

     

    In order to connect my Sharepoint Online List, I followed this documentation:

    https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-sharepoint-online-list 

     

    After that, I've published my Power BI into my workspace wollofing this documentation:

    https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-upload-desktop-files

     

    Once you've published your Power BI in your workspace, you need to follow these simple steps:

     

    1) open the settings of the Dataset (data source) published in the workspace

     

     

     

     

    2) From the "Data Source Credentials" section, click "Edit Credential" related to the "Web" data source

     

     

     

    3) Set the "Web" access settings as shown in the image 

     

     

     

    Hope this may help you.

     

    Bye!

    • NickTT's avatar
      NickTT
      Helper III
      3 years ago

      Correct... Sharepoint feeds no longer need Gateways. So don't set it up and it should work else you will get an error and the data wont refresh.

       

      I however did run into an issue still with getting errors pulling the data. I worked around the issue by creating a DataFlow to get the version info and the updating the PowerBI model to pull data from that DataFlow instead. Then defining "Allow Combining data from multiple sources." in the Project options of the DataFlow. I haven't had any issues since and I make this my standard approach for any version info in PowerBI from SharePoint Online.

       

       

      • harsh_bi_dev's avatar
        harsh_bi_dev
        Frequent Visitor
        3 years ago

        Hello NickTT,

        I can't create a DataFlows as I'm working on MyWorkspace.

         

        But thank you for the suggestions.

    • harsh_bi_dev's avatar
      harsh_bi_dev
      Frequent Visitor
      3 years ago

      Hello mzzwtr,

       

      If I'm configuring without gateway then also it is giving me same error. Please see the below screenshot.

       

      Could you please help me out with that?

       

      Thank you.

       

      • mzzwtr's avatar
        mzzwtr
        Regular Visitor
        3 years ago

        Hi harsh_bi_dev ,

         

        have you tried to check the "AuthDialog_Checkbox_SkipTestConnection" option?

         

        Let me know.

         

        Bye!