Forum Discussion

GuySev's avatar
GuySev
Icon for Advocate I rankAdvocate I
8 years ago

Connecting to other PBI file

Hi all,   I came across an issue and was wondering if anyone has encountered with the same problem. I've built several reports, connecting to multiple data sources (SQL Server, MySQL, Google Analy...
Need Help
Tips and Tricks
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
8 years ago

GuySev,

It is not possible to connect to Power BI Service dataset and other data sources in a single Power BI Desktop file. In your scenario, I would recommend you write specific SQL statement to get required rows and columns from MySQL database.



Regards,
Lydia

GuySev's avatar
GuySev
Icon for Advocate I rankAdvocate I
8 years ago

Thank you Anonymous, unfortunately I already tried this but my data is still too big. I guess for now I will split my report into smaller pieces of different files.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    GuySev,

    Yes. The workaround is to split the report to different reports. Or you can migrate data from MySQL to other database source like SQL Server or Oracle, then use DirectQuery mode.

    Regards,
    Lydia