search

microsoft / CopilotStudioSamples

MIT License
333 stars 269 forks source link

Empty data tables after Power Query Processing #113

Open capisoni opened 1 year ago

capisoni commented 1 year ago

Hello, I new in here and I am starting to build a Power BI report following instructions and using template provided. I realized that I can read data from bot and botcomponent tables while conversationscript still empty. After Power Query processing all information and table are empties and no data is avalilable on Power BI. Any clues of what should I do to fix it?

HenryJammes commented 1 year ago

Not sure what the issue is. Are you sure there are conversation transcripts in Dataverse? I've pushed a new version of the template here: https://github.com/microsoft/PowerVirtualAgentsSamples/blob/master/CustomAnalytics/PVA_Dashboard%20v1.1.pbit

capisoni commented 1 year ago

Hello, thanks for your answer. I have already figured out the issue. The data is on dataverse, but to retrive information using Power BI the TDS must be enable on MS Teams corporate environment. However due to limitations concerned to our MS Teams environment the administrator set TDS off.