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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Dilantha
Post Patron
Post Patron

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 Transform Data it displays error as below.

Capturepb.PNG

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


3 REPLIES 3
V-lianl-msft
Community Support
Community Support

amitchandak
Super User
Super User

@Dilantha , 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.

Dilantha_0-1622019338248.png


Any suggestions for that?
Thanks

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors