cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
lottee Regular Visitor
Regular Visitor

Relationship not Working when applying view as role function

Hello,

 

I have encountered this issue. I've pasted values everything but still doesn't work. Could anyone extend their help please. Thanks

 

Power BI issue.jpg

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
lottee Regular Visitor
Regular Visitor

Re: Relationship not Working when applying view as role function

Hello Amy,

 

I figured the problem. It's the spacing with the names. Thank you for your help and the advise. It's just that it's not the solution. Hope you won't stop helping me with other problems.

 

Thank you

View solution in original post

11 REPLIES 11
Community Support Team
Community Support Team

Re: Relationship not Working when applying view as role function

Hi @lottee ,

 

Please make sure the correct name of the Server and Database for the visuals. Did you changed the Database name? If yes, you can change your current query source to your correct name.

 

4.png

 

Best Regards,

Amy

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

lottee Regular Visitor
Regular Visitor

Re: Relationship not Working when applying view as role function

Hello @v-xicai ,

 

I don't know where to check coz it's not SQL server I am using it's just an excel and imported from my drive D. Please see screenshot.

 

Query View.jpg

Community Support Team
Community Support Team

Re: Relationship not Working when applying view as role function

Hi @lottee ,

 

There are some points you can considerate.

 

1.According to your error message, it refer to your data source have been changed, maybe changed the data source name or path to get data. So please check the path or name whether it is the same with your actual data source. Specially check the data source showing in your first screenshot .

 

1.png

 

 

 

 

 

 

 

 

 

2.Please check you have permission to access to the Data model.

 

Or this maybe a permission/authentication error. When you ever connect to data source in an unauthorized account, the corresponding credential would be created. You can change credential as steps below. Here take Dynamic 365 as an example.

 

a.In Power BI Desktop, click Data source settings.

 

2.png

 

 

 

 

 

 

b.Click Edit Permission ,or you can connect to blob storage again after click Clear Permission.

 

3.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

3.Upgrade PBI Desktop to the latest version 2.68.5432.841, and try it again.

 

Best Regards,

Amy

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

lottee Regular Visitor
Regular Visitor

Re: Relationship not Working when applying view as role function

Hello @v-xicai ,

 

Good morning!

 

My apology of not replying immediately. Anyway, I really appreciate your time and effort of sharing your ideas on how to solve my issue. But you know when I try to follow your step choosing the global permission, it says but it's working on my other geography with the same result in global permissionPBI Updates.jpg

Community Support Team
Community Support Team

Re: Relationship not Working when applying view as role function

Hi @lottee ,

 

Did the point1 and point3 make sense?

 

Best Regards,

Amy

lottee Regular Visitor
Regular Visitor

Re: Relationship not Working when applying view as role function

Hello @v-xicai ,

 

Yeah, I understand but still does not work on my end. I really don't know. Actually it's working for the other Geo's, Only this one Geo where I had this issue. They were created the same way. Maybe it would help if I'll share to you the files?

 

Please advise.

 

Thanks

Community Support Team
Community Support Team

Re: Relationship not Working when applying view as role function

Hi @lottee ,

 

a.This pbix is working fine for other users, right? How about logging in Power BI Desktop of other user's computer while use your own login account?

b.What would happen when you click "Close" button in your first error message page? How about restart the Power BI Desktop?

c.Did you create RLS ?when try to view as one role ,this error happened? Based on my test , it worked fine. You can check the RLS if the RLS value is exist in your data table.

d.Please check the path or name of your current data source whether it is the same with your actual data source.

 

If you still have this issue for Power BI, you'd better create a support ticket in Power BI Support to get further help.

 

Best Regards,

Amy

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Community Support Team
Community Support Team

Re: Relationship not Working when applying view as role function

Hi  @lottee ,
 
Does that make sense? If so, kindly mark my answer as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

 

Best regards
Amy Cai

 

Highlighted
lottee Regular Visitor
Regular Visitor

Re: Relationship not Working when applying view as role function

Hello Amy,

 

I figured the problem. It's the spacing with the names. Thank you for your help and the advise. It's just that it's not the solution. Hope you won't stop helping me with other problems.

 

Thank you

View solution in original post

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors