Forum Discussion

amiskow's avatar
amiskow
Helper I
6 years ago

Mobile App does not display the sql source report

Hi, I have a problem with displaying reports from a sql source. Excel reports (the same data) display correctly. What am I doing wrong?

 

PowerBI - project 

 

PowerBI - mobile view 

 

Mobile App

 

Need Help

3 Replies

  • v-alq-msft's avatar
    v-alq-msft
    Community Support
    6 years ago

    Hi, amiskow 

     

    I wonder if you are using import or DirectQuery mode for SQL data source. Have you used a data gateway and configured data source definition mapped to the corresponding dataset? Please check if it works properly in Power BI Service.

     

    For further information, you may refer Refresh data from an on-premises SQL Server database .

     

    Best Regards

    Allan

     

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

    • amiskow's avatar
      amiskow
      Helper I
      6 years ago

      You are right.

      The problem is only with a direct connection

      As I did import data, the report is displayed correctly

       

      It didn't solve my problem because I need refresh report on schedule, and this is only possible via direct connection 😞

      • v-alq-msft's avatar
        v-alq-msft
        Community Support
        6 years ago

        Hi, amiskow 

         

        For import connections, upon load all of the data defined by those queries will be imported into the Power BI cache. So when you import data, the report is displayed correctly  For DirectQuery connections, However, upon load no data is imported into the Power BI store. It needs to query the data source to get the data. Then a gateway is needed. The on-premises data gateway acts as a bridge to provide quick and secure data transfer between on-premises data (data that isn't in the cloud) and several Microsoft cloud services.

         

        First, you need to add a data source definition in your gateway,

         

        Then you need to map your dataset to the data source. If you're listed in the Users tab of the data source configured within the gateway and the server name and database name match, you see the gateway as an option to use with scheduled refresh.

         

        About how to configure scheduled refresh, please refer Manage your data source - SQL Server .

         

        Best Regards

        Allan

         

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