Forum Discussion

HO's avatar
HO
Frequent Visitor
7 years ago
Solved

Dataset connects to a source with DirectQuery in Power BI service, but data are imported in desktop

Hello,   I have made a report in power BI desktop, and published it to power BI service. When retrieving data to my report I chose to import for the Data Connectivity mode for all tables. I have no...
Interesting Links
Need Help
Tips and Tricks
  • HO's avatar
    HO
    7 years ago

    Yes it is very strange! It's only tables from a SQL database. 

     

    I can not share the file, unfortunately, since it contains sensitive information regarding my business. 

     

    I manage to solve the problem in a most non-elegant way: 

    1. Make a copy of the pbix file

    2. Remove all queries in the copy

    3. Copy and paste the content in Advanced Editior from original to copy. 

     

    When I published the copy to power bi serivce, everything was as expected. I have no idea what caused the error, but the important thing for me is that it works properly :) 

     

    Thank you for all suggestions!

     

    Best,

    HO

v-lili6-msft's avatar
v-lili6-msft
Community Support
7 years ago

hi, HO 

This is very strange, what is your datasource? and could you share your sample pbix file(import) for us to have a test?

 

Best Regards,

Lin

 

HO's avatar
HO
Frequent Visitor
7 years ago

Yes it is very strange! It's only tables from a SQL database. 

 

I can not share the file, unfortunately, since it contains sensitive information regarding my business. 

 

I manage to solve the problem in a most non-elegant way: 

1. Make a copy of the pbix file

2. Remove all queries in the copy

3. Copy and paste the content in Advanced Editior from original to copy. 

 

When I published the copy to power bi serivce, everything was as expected. I have no idea what caused the error, but the important thing for me is that it works properly :) 

 

Thank you for all suggestions!

 

Best,

HO