Don't miss your chance to take the Fabric Data Engineer (DP-700) exam on us!
Learn moreWe've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. Register now
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 Transform Data it displays error as below.
How to fix that? Data load fine in database.
After this case I loaded data from same mysql view. But I couldnt see updated data from new imported table. Only 3000 records avalable. Also I searched for filters that applied to dashboard. their is none.
I donno how this happen. Can ypu provide better answer.
Thank You
You could refer to this thread:
Hope it will help.
@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
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
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 51 | |
| 37 | |
| 35 | |
| 19 | |
| 17 |
| User | Count |
|---|---|
| 69 | |
| 65 | |
| 39 | |
| 33 | |
| 23 |