Forum Discussion

Salvador's avatar
Salvador
Responsive Resident
9 years ago

Storing and using information from a dynamic data source using PBI desktop.

Hello,   This is something that I've worked in for a couple of months, and have been successfully using it for 3 months, and now would like to share with the community. If you want to know where th...
Show and Tell
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Salvador   how does the 'HistoricalData' table gets created?.. it was not mentioned anywhere in the ps script or steps u created?

Salvador's avatar
Salvador
Responsive Resident
7 years ago

Hello Anonymous,

 

It's explained in step 5, basically it's connecting to the folder where you are going to store the csvs that register the historic data.

 

Regards,

Salvador.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Salvador does this method work with pbi service?  

    • Salvador's avatar
      Salvador
      Responsive Resident
      7 years ago

      Hi Anonymous,

       

      Yupp, but you have to make thoose csvs available to be uploaded onto the service, I used a data gateway ^^

      • Clara's avatar
        Clara
        Advocate II
        7 years ago

         Salvador Both of your files (from steps 3 and 4) show up as unavailable. Could you reupload them, please? Or please let me know if you'd rather send them to my email?

         

        Sorry for the bother! This looks fantastic and would really help me a lot. Thank you very much for sharing!

  • cosminc's avatar
    cosminc
    Post Partisan
    7 years ago

    Hi,

    it was reinstalled Windows on my computer and i have an issue

    the script opens the power bi which need to be refreshed and to export but something don't work and rests opened

    below the PBI exporter log:

     

    Executing PBI_Exporter.ps1 at 2019-07-16_13_58_02
    Launching Power BI
    Waiting 30 seconds for PBI to launch
    Assuming PBI is launched and ready now
    Connecting to PBI using AMO
    Exception calling "LoadFile" with "1" argument(s): "The system cannot find the file specified. (Exception from HRESULT: 0x80070002)"
    The system cannot find the file specified. (Exception from HRESULT: 0x80070002)
    Script finished with errors at 07-16-2019_13_58_34
    Closing the connection
    You cannot call a method on a null-valued expression.

     

     

    any idea what i have to do?

    thanks,

    Cosmin