Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Data Loading issue from mysql views

Hi, I had mysql view with 150 000 records. It modified with stored function. I have checked it with table view and data seems to be fine. When logged in to power bi desktop and refresh data from Tr...
Need Help
amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , Seems one of the two reasons

1. Your desktop IP is not having access to my SQL

2. You user do not have access one ore more table or database 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi amitchandak ,
    Still couldnt fix the issue.
    Is their any limitations in power bi to import data from views with stored functions ?
    When it execute from database we can retreive data successfully.


    I tried to call that mysql view (with stored function) from select query in advanced editor,
    Still having same issue.


    Any suggestions for that?
    Thanks