Skip to main content
Solved

PowerBI Direct Query

Hi All,

I am connecting Nintex with Power BI. It is connected, but when I complete step 7, it asks for Import or Direct Query. I am using Import, but data import is slow and because when I start the workflow with beacons in it, data shows up after 2-3 hours, which is not ideal. So, I am trying Direct Query, hoping the data will be updated instantly in the report. I am no expert in PowerBI so apologies if any silly mistake. However, I am getting the attached error when I try with Direct Query.

Is this something anyone can help with, please?
I have noticed that in step 9 Tip says Data fetching may take up to 3 hours.
Nintex Help Link - https://help.nintex.com/en-US/analytics/OData/PowerBI.htm

3 replies

Jake
Userlevel 6
Badge +13

Hi @Natha 

Reporting data via the analytics platform is not real-time there is always a delay which typically is around a couple hours.
 

If you require much more real-time reporting of data it might be better to store the data to SQL using the workflow its self and then reporting from the SQL data.

The Nintex analytics feeds are more a daily health check that updates a few times a day to give a broader prospective of the overall platform health, It was never designed to handle real-time reporting. 

Jake

Jake
N
Userlevel 2
Badge +4

 Hi @Jake,

Thanks for your prompt response with the detailed answer. That sorts out my question and thanks for suggestion on how to do it. I appreciate it.

N
Userlevel 2
Badge +4

Hi @Jake ,

I am adding my data into SQL and I want the URL of a particular task, but I am facing an issue. The URL in the Nintex email and Assignee task works fine, but when I add it into the table, I get a different string. I want to show the task URL link on the Dashboard so that when they click on the link, it takes them to Nintex. Can you help please.

Getting in SQL
tf_ed4e83f03ed74b5493b8224d64267b2f_form_url
tf_ed4e83f03ed74b5493b8224d64267b2f_task_name_link

In NWC email
https://urlsand.esvalabs.com/?u=https%3A%2F%2Fishidaeuropeltd.workflowcloud.com%2Ftask-forms%2F04bff17c-6803-5ccd-914f-43bdaa02ed8d_04a689ad-67cd-50bf-b202-64c43d1e6feb&e=a98c5c08&h=47b97a18&f=y&p=n

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings