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.