Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
Damola
Helper I
Helper I

Inability to locate the Q&A Set up feature in my Power BI Q&A

Q&A Isuue.PNGQ&A Setup2.PNG

 

Hello all,

 

The first screenshot shows the Q&A feature in my Power BI Desktop and the second screenshot shows the Q&A setup I can't find on my Q&A feature. The icon beside the PowerBI Q&A feature is usually beside the 3 dots(...) at the right hand corner. 

 

My Power BI Desktop is updated so I don't know the reason why I can't find this icon. Could it be as a result of the fact that I use a Live Connection? I just don't know.

 

Looking forward to your thoughts.

 

Thanks

 

1 ACCEPTED SOLUTION
v-janeyg-msft
Community Support
Community Support

Hi, @Damola 

 

If you use LC mode, You can use Q&A in service:

Power BI Q&A supports the following configurations of data sources in the Power BI service:

  • Import mode
  • Live connect to Azure Analysis Services
  • Live connect to SQL Server Analysis Services (with a gateway)
  • Power BI datasets.

Power BI Q&A currently does not support the following configurations:

  • Object level security with any type of data source
  • Composite models
  • Reporting Services

More details:

Limitations of Power BI Q&A - Power BI | Microsoft Docs

 

You need to enable Q&A for live connections in Power BI?

Use Q&A with live connections in Power BI - Power BI | Microsoft Docs

 

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.

 

Best Regards,
Community Support Team _ Janey

 

View solution in original post

10 REPLIES 10
Damola
Helper I
Helper I

Hello @v-janeyg-msft when I sent my colleague the attached screenshot, she said there is a gateway on the   server and there is no issue with the gateway. Is this right? 

 

Also, attached are the screenshots of the message I got when I tried to use the Q&A on PowerBI service. My colleague said it may be due to Object Level Security in Power BI?

 

Looking forward to hearing from you.

 

Thanks

 

Looking foward to hearing from you

 

QA Issue.PNGQA Issue2.PNG

 

 

ST.PNG

Hi, @Damola 

 

I already mentioned this in my previous reply.

vjaneygmsft_0-1639621608684.png

And the error message also clearly indicates that the QA function can't be used in these situations.

vjaneygmsft_1-1639621643293.png

 

 

 

 

This requires you to confirm with the report developer.

If your data source comes from the cloud, you can use it without a gateway.

If you don't meet these conditions, please let me know.

 

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.

 

Best Regards,
Community Support Team _ Janey

Hello @v-janeyg-msft Like I said earlier, the model author said there is object level security with the data source. 

 

We have not moved our data source to cloud as well.

 

I think we won't be able to use the Q&A function for now.

 

Thank you for the clarification.

 

Thanks

Damola
Helper I
Helper I

Thanks @v-janeyg-msft for your inputs.

 

I think this should solve it. I am not sure my account is set as admin but I'll discuss with my manager and provide and update.

 

Regards

@Damola  Any updates?

v-janeyg-msft
Community Support
Community Support

Hi, @Damola 

 

If you use LC mode, You can use Q&A in service:

Power BI Q&A supports the following configurations of data sources in the Power BI service:

  • Import mode
  • Live connect to Azure Analysis Services
  • Live connect to SQL Server Analysis Services (with a gateway)
  • Power BI datasets.

Power BI Q&A currently does not support the following configurations:

  • Object level security with any type of data source
  • Composite models
  • Reporting Services

More details:

Limitations of Power BI Q&A - Power BI | Microsoft Docs

 

You need to enable Q&A for live connections in Power BI?

Use Q&A with live connections in Power BI - Power BI | Microsoft Docs

 

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.

 

Best Regards,
Community Support Team _ Janey

 

Thanks for your thoughts @v-janeyg-msft I think I understand where the issue is. I am new in my organization so I am still trying to figure out a lof of things. 

 

Attached is a screenshot of my screenshot showing I don't have any gateways. Kindly confirm if there is no gateway and see if the second screenshot is where to download one.

 

My boss said we use a standard gateway but I am not sure as shown in the attached screenshot.

 

Looking forward to hearing from you.

 

ThanksGT.PNG Gateway.PNG

Hello @Damola 

 

Downolad standard mode, and you also need to confirm whether your account is admin or has permission to set the gateway, because if it is the first download, you need to create a gateway cluster to use it.

Reference: use-a-gateway

vjaneygmsft_0-1639359405730.png

You can click on these links to set up the gateway if you are in trouble.

 

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.

 

Best Regards,
Community Support Team _ Janey

lbendlin
Super User
Super User

your visual may not be wide enough?

 

lbendlin_0-1639013675697.png

 

Thanks @lbendlin I am not sure that's the issue.  I am thinking it may be due to the fact that I use a Live Connection as I think the feature is currently available for only import source. I willQis.PNG appreciate the thoughts of others. 

 

Attached is a wider screenshot of my screen again.

 

Thanks

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.